Excel VLOOKUP Step by Step Tutorial

Excel VLOOKUP Error Messages

The following error messages are associated with VLOOKUP.

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


• It will also be displayed if the range for the table array argument is inaccurate. If this argument includes empty columns on the left of the table array.

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

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