Excel Vlookup Tutorial Part 5 - Fix Your Vlookup Error

Occurs if the Vlookup function fails to find a match to the supplied lookup_value.

The cause of this generally depends on the supplied [range_lookup] argument:

If you still can't understand why you are getting this Vlookup error, check out the Vlookup #N/A Error page.

Occurs if either:

• The supplied col_index_num argument is greater than the number of columns in the supplied table_array.

• The formula has attempted to reference cells that do not exist.
  This can be caused by relative referencing errors when the Vlookup is copied to other cells.

If you need further help with this Vlookup error, check out the Vlookup #REF! Error page.

Occurs if either:

• The supplied col_index_num argument is < 1 or is not recognised as a numeric value.

• The supplied [range_lookup] argument is not recognised as one of the logical values TRUE or FALSE.

If your Vlookup function is simply returning the wrong value, check the following:

1. Are the values you are searching in the left column of the table_array?
   For the Vlookup function to work, the values that you are searching must be in the left column of the table_array.
   
   
2. If the [range_lookup] argument is set to TRUE (or omitted), the function will return the closest match below the lookup_value. For this to work correctly, the left column of the table_array must be in ascending order.
   
   
3. Check that the col_index_num argument refers to the required column.
   Remember that this is the column number counting from the first column of the table_array. It is not necessarly the same as the spreadsheet column number.
   
   
4. If the [range_lookup] argument is set to FALSE, the Vlookup function requires an exact match. Check that there is only one match to the lookup_value within the left column of your table_array. Note that if there is more than one match, the Vlookup function will use the first match that it encounters.