The #NAME? guide
#NAME? means Excel found a word in the formula it doesn't recognise. Almost always it's one of four things: a misspelled function, text without quotes, a range missing its colon, or a function name from another language's Excel.
The four usual causes
| Formula | What's wrong | Fixed |
|---|---|---|
=AVERGE(D2:D7) | Misspelled function | =AVERAGE(D2:D7) |
=SUM(D2D7) | The range has no colon, so D2D7 reads as a name | =SUM(D2:D7) |
=IF(G2>=250,Yes,No) | Text without quotes | =IF(G2>=250,"Yes","No") |
=MAK(D2:D7) | The Turkish name in English Excel | =MAX(D2:D7) |
How to find it
Click the cell and read the formula bar. While you type a function name, Excel suggests the ones it knows: if no suggestion shows up, the name is wrong. A correct function name turns upper case when you press Enter; a wrong one stays as you typed it.
Text needs double quotes
Inside a formula, any word that isn't a function, a cell or a defined name has to be in double quotes: "Yes". Without them Excel looks for something named Yes. Single quotes don't count; Excel uses those for sheet names.
Function names are translated
Excel translates function names into the language it's installed in: VLOOKUP is DÜŞEYARA in Turkish, SVERWEIS in German, BUSCARV in Spanish. A formula copied from a tutorial in another language gives #NAME?. The separator can change too: some languages use ; between arguments instead of ,.
Common mistakes
- Fixing the spelling and leaving the text unquoted. The formula still shows #NAME?.
- A comma instead of the colon.
SUM(D2,D7)adds two cells, not the range between them. No error, just a wrong total. - A newer function in an older Excel. XLOOKUP, FILTER and UNIQUE give #NAME? in Excel 2019 and earlier.
Don't hide #NAME? with IFERROR: it always means the formula itself is wrong. Other errors: #DIV/0!, #VALUE!, #REF!.
FAQ
- What does #NAME? mean in Excel?
- Excel found a word it doesn't recognise: a misspelled function, text without double quotes, a range missing its colon, or a function name from another language version.
- Why does my IF formula show #NAME?
- Usually the text results have no quotes: =IF(A2>10,Yes,No). Write them in double quotes: =IF(A2>10,"Yes","No").
- Why do I get #NAME? with XLOOKUP?
- Your Excel version doesn't have it. XLOOKUP needs Excel 2021, 2024, Microsoft 365 or Excel for the web; use VLOOKUP or INDEX and MATCH in older versions.
- Can a function name in another language cause #NAME??
- Yes. Excel uses function names in its own language, so a formula with SVERWEIS or DÜŞEYARA fails in English Excel. Use the English name, VLOOKUP.



































































