Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
Fix the #NAME? error
Excel & Google SheetsWhat #NAME? means
#NAME? means the spreadsheet does not recognize a name in the formula. It usually points at a misspelled function, a named range that does not exist, or text that is missing its quotation marks.
Common causes
- A function name is misspelled, e.g. =VLOKUP instead of =VLOOKUP.
- Text in the formula is missing its surrounding quotation marks.
- A named range is referenced that was never defined or was deleted.
- A newer function (like XLOOKUP) is used in a version that does not support it.
- In Google Sheets, an Excel-only function name was pasted in, or vice versa.
Example fix
Broken
=VLOKUP(D2, A:B, 2, FALSE)Fixed
=VLOOKUP(D2, A:B, 2, FALSE)The function name was misspelled. #NAME? almost always points at a typo.
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How to fix it
- 1Re-read the function name carefully for a typo; the formula editor autocompletes valid names as you type.
- 2Make sure every piece of literal text is wrapped in straight double quotes, e.g. "Sales".
- 3Check Formulas → Name Manager (Excel) or Data → Named ranges (Sheets) for the name you referenced.
- 4If you used XLOOKUP, FILTER, or another modern function and it is not recognized, switch to INDEX/MATCH or check your version.
- 5Confirm the function exists on the platform you are using — some functions are Excel-only or Sheets-only.
Stop hunting errors by hand.
Upload your spreadsheet and the Auditor flags every #NAME? and broken formula at once — or paste this one formula and get the fix explained.
Frequently asked
Why does XLOOKUP show #NAME? in my Excel?
XLOOKUP is only available in Microsoft 365 and Excel 2021+. Older versions do not recognize it — use INDEX/MATCH instead.
Can a missing quote cause #NAME?
Yes. If you write =IF(A2=Sales,...) the word Sales looks like an undefined name. Wrap it in quotes: "Sales".