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.
- This error is displayed if the column index number argument is greater than the number of columns in table array.