Excel VLOOKUP Error Messages
- If the lookup_value is not found in the first column of the table_array, VLOOKUP returns the #N/A error value.
- If the col_index_num argument is greater than the number of columns in table_array, VLOOKUP returns the #REF! error value.
- If the table_array argument includes empty columns on the left of the table_array, VLOOKUP returns the #N/A error value.
