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.
February 26th, 2008 at 11:33 am
… what does “False” at the end means?
Anyway, thanks for simple and strait explaination of how the funcion works.
February 26th, 2008 at 9:38 pm
The “False” means exact matches only (and if you use “True” you also need to sort the column)