Thursday, October 11, 2007

Excel VLOOKUP function

Syntax:
VLOOKUP(A2, D$11:E:22, 2, False)

Means:
If the value of cell A2 matches a value in the supplied range (Cells D11 to E22), the function's result is the value of the second column from the range, from the row containing the matching value.

This function and the matching HLookup function can be very handy.

2 comments:

Anonymous said...

... what does "False" at the end means?

Anyway, thanks for simple and strait explaination of how the funcion works.

Anonymous said...

The "False" means exact matches only (and if you use "True" you also need to sort the column)