Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

v look up

ResolvedVersion 2003

Jordana has attended:
Excel Intermediate course

V look up

not sure how to do this - help please?

RE: v look up

Hello Jordana,

My name is Greg Eze and I am one of the trainers at Best.
Vloojup searches for the value in the first column of a table and returns a value in the second table.

In term of Vlookup, I can give you an example of how it works if it is any good to you.

1. Copy this table - from range A1: B4 :
salesperson

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.