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.

Frequently asked questions

  • What does #NAME? error mean in Excel? #NAME? error occurs when Excel doesn't recognize text in your formula. Common causes include misspelled function names, missing quotation marks around text, undefined named ranges, or using functions not available in your Excel version. Excel is saying 'I don't know what this name means.'
  • How do I fix #NAME? error in Excel? Fix #NAME? error by: 1) Check function spelling (SUMIF not SUMF); 2) Add quotes around text values ("Apple" not Apple); 3) Verify named ranges exist in Name Manager; 4) Check if the function exists in your Excel version; 5) Ensure add-ins are enabled for special functions.
  • Why does my formula show #NAME? when the function exists? Even with correct function names, #NAME? can occur if: the function requires an add-in that's not enabled, you're using a newer function in an older Excel version (like XLOOKUP in Excel 2016), or there's a regional setting issue. Also check for invisible characters copied from websites.
  • How do I check if a named range exists? Check named ranges by: 1) Press Ctrl+F3 to open Name Manager; 2) Look in the Name Box dropdown (left of formula bar); 3) Go to Formulas > Defined Names > Name Manager. If your named range isn't listed, create it or correct the spelling in your formula.
  • What functions cause #NAME? in older Excel versions? Functions that cause #NAME? in older versions include: XLOOKUP, XMATCH, FILTER, SORT, UNIQUE, SEQUENCE (Excel 365/2021 only); IFS, SWITCH, TEXTJOIN, CONCAT (Excel 2019+); LAMBDA (Excel 365 only). Use alternative functions like VLOOKUP, INDEX/MATCH for compatibility.

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.