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:
... what does "False" at the end means?
Anyway, thanks for simple and strait explaination of how the funcion works.
The "False" means exact matches only (and if you use "True" you also need to sort the column)
Post a Comment