Excel Vlookup Tutorial Part 5 - Fix Your Vlookup Error

If you get a Vlookup error, use the table below to identify the most likely cause of this:

Common Vlookup Errors
#N/A -

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

The cause of this will generally depend on the supplied [range_lookup] argument:
if [range_lookup] = TRUE
(or is omitted)
- the #N/A error is likely to be because the smallest value in the left-hand column of the table_array is greater than the supplied lookup_value
if [range_lookup] = FALSE - the #N/A error is likely to be because an exact match to the lookup_value is not found in the left-hand column of the table_array
If you still can't understand why you are getting this Vlookup error, check out the Vlookup #N/A Error page
#VALUE! - Occurs if either:
- The supplied col_index_num argument is < 1 or is not recognised as a numeric value
or
- The supplied range_lookup argument is not recognised as TRUE or FALSE
#REF! - Occurs if either:
- the supplied col_index_num argument is greater than the number of columns in the supplied table_array
or
- 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

Further Vlookup troubleshooting tips are provided, in the form of a handy Vlookup Quick Reference Card, on the Microsoft Office website.

Return to the Excel Vlookup Tutorial Page

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net