Spreadsheet error
How to fix the #NAME? error
TL;DR
#NAME? means Excel does not recognize a name in the formula — usually a misspelled function, missing quotes around text, or a named range that does not exist.
What it means
The #NAME? error means the formula parser encountered a word it does not understand. This is almost always a typo in a function name, an unquoted text value, or a reference to a deleted named range.
Common causes
- •Misspelled function name: =SUMF(A:A) instead of =SUM(A:A).
- •Text literal without quotes: =IF(A2=West, "yes", "no") instead of =IF(A2="West", "yes", "no").
- •Named range that was deleted or never defined.
- •Using a function that does not exist in your Excel version (XLOOKUP in Excel 2016).
- •Missing colon in range: =SUM(A1A10) instead of =SUM(A1:A10).
How to fix it
1.Check function spelling
- Click the cell and read the formula bar.
- Look for a function name highlighted in the formula.
- Excel autocomplete will not suggest invalid names.
2.Quote your text
- Any text literal in a formula must be in double quotes.
- =IF(A2="West", ...) not =IF(A2=West, ...)
3.Check named ranges
- Formulas > Name Manager
- Verify the name exists and points to a valid range.
Example
Broken
=IF(A2=West, "yes", "no")Fixed=IF(A2="West", "yes", "no")The unquoted word "West" looked like a named range to Excel, but there was no such name defined.
Prevention
- Let autocomplete fill function names — avoids typos.
- Never embed text directly without quotes.
- Use Name Manager to audit defined names when a workbook grows complex.
Related errors
Let FormulaPad debug it for you
Paste your broken formula and the error message — get a diff and an explanation in seconds.
Debug a formula