Microsoft Office Tutorials and References
In Depth Information
l The cell containing the
formula displays the
to the lookup value.
Type another lookup value.
l The cell containing the formula displays
the value corresponding to the lookup
Did You Know?
The closely related but less commonly used
HLOOKUP function finds a value in a row based on
another value in the same row.
When using VLOOKUP , if you are searching text
data, make sure the column you are searching does
not contain any leading spaces, trailing spaces,
inconsistent use of curly and straight quotation
marks, or nonprinting characters. These situations
can cause VLOOKUP to bring back an incorrect
result. For the same reason, if you search dates,
make sure you format your dates as dates, not text.
Chapter 4: Manipulate Records