excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Kaylee has attended:
Word Intermediate course
Word Advanced course
Excel Intermediate course
Excel Advanced course

Excel

vlookup

RE: excel

Hi Kaylee,

Thanks for the post, I assume that you would like some information about VLOOKUP. Ok here goes:
The idea of VLOOKUP is that you can get Excel to look for a value in the left most column of a table of data; and display a corresponding value in the same row of the table. The value that Excel looks for in the left most column is called the lookup value. The entire table/data area is called the table array. Each column in the table array is assigned a number by Excel - the column containing the possible lookup values is column 1, then each of the other columns in the table array is numbered consecutively from left to right (2, 3, 4 etc). You also need to specify if you want an exact match to the lookup value or an approximate match (where something that is close to the lookup value is sufficient). This is what is referred to as the range lookup where entering false means Excel needs to find an exact match; true means that Excel can find an approximate match. The structure of the function is =VLOOKUP(lookup value, table array, column number, range lookup) and it will display the value from the column number that you specify.
I hope that has helped, if so please click the resolved link, regards Pete


 

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips


Server loaded in 0.08 secs.