Fix #NAME? Error in Excel

This error occurs when Excel doesn't recognize text in a formula. Usually caused by misspelled function names or missing quotation marks.

Why this happens

  • Misspelled function name
  • Missing quotation marks around text
  • Undefined named range
  • Function not available in your Excel version

How to fix it

  • Check spelling of function names
  • Add quotation marks around text values
  • Define the named range or correct the name
  • Use an alternative function for older versions

#NAME? spelling and locale

  • Typo in function name — compare to this directory spelling.
  • Missing quotes around text strings in formulas.
  • Localized workbook — see [international function names](/guides/international-excel-function-names/).

Functions that often show this error

  • INDIRECT: Returns the reference specified by a text string. References are immediately evaluated to display their contents.
  • REGEXTEST: Returns TRUE if text matches a regular expression pattern, otherwise FALSE.
  • REGEXEXTRACT: Extracts text that matches a regular expression pattern, optionally from a capture group.
  • REGEXREPLACE: Replaces text that matches a regular expression pattern with replacement text.

Extended #NAME? diagnostic steps

  • Compare formula spelling to the English function directory even if Excel UI shows localized names.
  • Undefined names in Name Manager — delete stale named ranges after restructuring workbooks.
  • External links to closed workbooks may show #NAME? until source files open on the same path.
  • Dynamic array functions in Excel 2019 show #NAME? — confirm Microsoft 365 or Excel 2021 before deploying.

Prevention checklist

  • Type function names in lowercase and let Excel autocomplete — reduces typos vs manual caps.
  • Quote all text strings; unquoted text is interpreted as a name and triggers #NAME?.
  • Run Formulas → Error Checking after bulk find-replace on function names.

#NAME? examples that trip up experienced users

  • =SUm(A1:A10) — typo in function name; Excel treats unknown names as #NAME?.
  • =IF(A1>10, Yes, No) — Yes and No must be quoted as "Yes" and "No".
  • =VLOOKUP(A1,Table1,2,FALSE) when Table1 was renamed or deleted in Name Manager.
  • =XLOOKUP(A1,B:B,D:D) in Excel 2019 — function does not exist on that version.
  • Localized workbook: PROCV vs VLOOKUP mismatch until translated for your Excel language.
  • Broken external link: =[OldFile.xlsx]Sheet1!A1 when OldFile moved or was renamed.

Step-by-step #NAME? elimination

  • Click the cell and read the formula bar — identify the token Excel cannot resolve.
  • Formulas → Name Manager — delete orphan names pointing to #REF! ranges.
  • Formulas → Error Checking → Trace Error on a copy of the workbook.
  • Compare function spelling to /functions/ pages in this English directory.
  • Test the same formula on Sheet2 with literal values instead of named ranges.
  • If opening from email, click Enable Content and verify linked workbooks are available.

Locale and compatibility resources

  • International function names guide (/guides/international-excel-function-names/) for PROCV, SVERWEIS, BUSCARV.
  • VLOOKUP (/functions/vlookup/), XLOOKUP (/functions/xlookup/), SUMIF (/functions/sumif/) — verify spelling.
  • Fix formula errors hub (/guides/fix-excel-formula-errors/) when multiple error types appear after migration.
  • Before deploying M365 dynamic formulas, confirm every recipient has Excel 2021 or subscription desktop.
  • IFERROR and IFNA cannot fix #NAME? caused by typos — correct the function name first.

Quick reference: #NAME? vs other errors

  • #NAME? means Excel does not recognize a name or function — not a failed lookup (#N/A) or wrong type (#VALUE!).
  • After fixing spelling, recalculate the sheet (F9) and confirm Automatic calculation mode is enabled.