Excel's VLOOKUP Function

By Ted French, About.com Guide

Excel VLOOKUP Error Messages

The following error messages are associated with VLOOKUP.

#N/A error :

• This error is displayed if the lookup value is not found in the first column of the table array.


• It will also occur if the range for the table array argument is inaccurate. For example, the argument may include empty columns on the left side of the table array.

#REF!:

• This error is displayed if the column index number argument is greater than the number of columns in table array.

Previous

• Using Excel's VLOOKUP Function
• Entering the Tutorial Data
• The VLOOKUP Dialog Box
• The Lookup Value Argument
• The Table Array Argument
• The Column Index Number Argument
• The Range Lookup Argument
• Using the VLOOKUP Function
• Excel VLOOKUP Error Messages

Next