How to Fix #NAME? Errors in Excel
A #NAME? error means Excel encountered something in your formula it cannot identify — a misspelled function name, an undefined named range, or text without quotes. Here is how to find and fix every instance.
Find all #NAME? errors automatically — upload your spreadsheet and ExcelErrorFinder will locate every instance across all sheets.
Free Audit →What Does #NAME? Mean?
When Excel displays #NAME?, it is telling you: "I found a word in this formula that I don't recognise as a function, a cell reference, or a defined name." It is almost always a syntax or typing issue — not a data problem — which means it is almost always fixed in seconds.
The 5 Most Common Causes
1. Misspelled Function Name
The most frequent cause. =SUMM(A1:A10), =VLOKUP(), or =AVERGE() — Excel cannot recognise the misspelled name so it returns #NAME?.
Fix: Click the cell, check the formula bar, and correct the spelling. Start typing the function name and use Excel's autocomplete dropdown to select the correct spelling.
2. Undefined Named Range
If your formula uses =SUM(Revenue) but "Revenue" has not been defined as a named range (or was deleted), Excel returns #NAME?.
Fix: Go to Formulas → Name Manager. Check if the name exists and points to the correct range. If missing, click New to create it. If deleted, recreate it.
3. Text Without Quotation Marks
=IF(A1=Yes, "OK", "No") — Excel tries to find a named range called "Yes". When it can't, it returns #NAME?. Text values in formulas must always be inside double quotes.
Fix: =IF(A1="Yes", "OK", "No") — wrap all text strings in double quotes.
4. Function Not Available in Your Excel Version
Functions like XLOOKUP, FILTER, UNIQUE, and SEQUENCE are only available in Excel 2019 and Microsoft 365. Opening a file with these functions in Excel 2016 or earlier returns #NAME?.
Fix: Use a compatible alternative (VLOOKUP instead of XLOOKUP), or ensure all users have a compatible version of Excel.
5. Missing Add-In
Some functions (particularly statistical ones from the Analysis ToolPak) return #NAME? if the add-in providing them is not loaded.
Fix: Go to File → Options → Add-ins → Manage: Excel Add-ins → Go and enable the required add-in.
How to Find All #NAME? Errors in Your Workbook
- Press Ctrl+F to open Find
- Type
#NAME?in the search box - Change the "Look in" dropdown to Values
- Click Find All
Excel lists every cell containing #NAME?. Click any row in the list to jump to that cell.
To check all sheets at once without repeating this process, use the ExcelErrorFinder audit tool — it scans every cell across every sheet and lists all errors with cell addresses and formula text.
Preventing #NAME? Errors
- Always use Excel's formula autocomplete (start typing a function name and select from the dropdown) — this prevents misspelling
- Before deleting a named range, use Ctrl+F to search for its name and confirm no formulas reference it
- If sharing files with users on older Excel versions, avoid using functions introduced after Excel 2016
- Always wrap text criteria in double quotes —
"text"nottext
Frequently Asked Questions
Why does #NAME? appear after I copied a formula from another workbook?
The formula may reference a named range that exists in the source workbook but not in your workbook. Check Formulas → Name Manager for any names referenced in the formula.
Can #NAME? appear even if the function name is spelled correctly?
Yes — if the function requires an add-in that is not installed, or if the function was introduced in a newer version of Excel than you are using.
Does #NAME? cascade to other cells?
Yes. Any formula that references a cell showing #NAME? will typically also return an error. Fix the root cause and dependent cells update automatically.