Excel VLOOKUP Error Messages
The following error messages are associated with VLOOKUP.AN #N/A error is displayed if:
- The lookup value is not found in the first column of the table array.
- 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.
- The range lookup argument is set to true and an exact match for the lookup_value argument cannot be found in the first column of the table array.
- This error is displayed if the column index number argument is greater than the number of columns in table array.