Explanation
The #NAME?
error shows up when Excel can’t recognize something.
Frequently, the #NAME?
comes up whenever a function name is misspelled, but there are other causes, as explained below.
Fixing a #NAME?
error is usually just a matter of correcting spelling or a syntax problem.
The function name “VLOOKUP” is spelled incorrectly, and the formula returns #NAME?
Source data contains #NAME!
If the source data for a function contains a #NAME?
error, the calling function might return a #NAME?
For example, in the worksheet below, the range C3:C7 contains a #NAME?
error, so the SUM function also returns #NAME?
To fix this problem, address the errors in the source data.
Named range misspelled
In the example below, thenamed range"data" equals C3:C7.
In F2, “data” is misspelled “daata” and the MAX function returns #NAME?
Readmore about named ranges here.
This can cause a #NAME?
error when no match is found.
In the example below, theLEN functionis used to get the length of the word “apple”.
In B3 the formula is entered without the text string “apple” in quotes ("").
Because apple is not a function name or named range, the result is #NAME?
“apple”).
error
How to fix the #REF!
error
How to fix the #NAME?
error
How to fix the #VALUE!
error
How to fix the #NUM!
error
How to fix the #NULL!
error
How to fix the #SPILL!
IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.
you’ve got the option to use ERROR.pop in to test for specific kinds of errors.
If no error exists, ERROR.pop in returns #N/A.
See below for a key to the error codes returned by ERROR.bang out.
…
Related videos
Excel formula error codes
How to trace a formula error
