#NAME? Error Hub: Complete Fix Guide
Pairs with #NAME? how-to. Use for spelling, quotes, and named-range failures from the Error Directory.
What #NAME? means
Excel does not recognize a token as a function or defined name. Not a lookup miss (#N/A) and not a type error (#VALUE!).
Fix checklist
- Correct function spelling (IntelliSense)
- Put text criteria in straight double quotes
- Formulas → Name Manager — repair broken names
- Replace _xlfn. functions on older Excel
- Re-type curly quotes from web/Word pastes
=IF(A1="Open","Y","N")
=VLOOKUP(B1,D:E,2,FALSE)
=SUM(Sales[Amount])