Resources > Formula Help
How Do I Fix #NAME? Errors in Excel?
Last Updated: June 2026
Quick Answer
A #NAME? error means Excel does not recognize part of your formula.
Common Causes
- Misspelled function names
- Missing quotation marks around text
- Invalid named ranges
- Functions not available in your Excel version
Example: Missing Quotes
Bad:
=IF(A2=Complete,"Yes","No")
Good:
=IF(A2="Complete","Yes","No")
Example: Misspelled Function
=XLOKUP(A2,B:B,C:C)
Excel will return #NAME? because XLOOKUP is misspelled.
