|
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.
|
