Microsoft Office Tutorials and References
In Depth Information
● If the range_lookup argument is left blank or set to TRUE , and lookup_value is larger
than all values in the named range, the largest value in the named range is returned.
● If the range_lookup argument is set to FALSE , and VLOOKUP doesn’t find an exact
match for lookup_value , the function returns an #N/A error.
As an example of a VLOOKUP function, consider the following data, which shows
an Excel table with its headers in row 2 and the first column in column B of the
If the =VLOOKUP (E3, Table1, 2, TRUE) formula is used, when you type CI02 in cell E3
and press Enter, the VLOOKUP function searches the first column of the table, finds an
exact match, and returns the value Northwind Traders to cell F3.