How to Fix the #NAME? Error in Excel
The #NAME? error means Excel does not recognize something in your formula — usually a misspelled function, missing quotation marks around text, or an unknown name. Here is how to find the cause and fix it.
The #NAME? error is Excel's way of saying "I don't recognize something you typed." It almost always points to a small typo in a formula — and once you know where to look, it is quick to fix.
The common causes of #NAME?
- A misspelled function name — for example =SUMM(A1:A5) instead of =SUM(A1:A5).
- Text in a formula without quotation marks, like =IF(A1=Paid,"Yes","No") instead of =IF(A1="Paid","Yes","No").
- A named range that does not exist or was deleted.
- A missing colon in a range, such as =SUM(A1 A5) instead of =SUM(A1:A5).
- A function from a newer Excel that your version does not have.
Step 1: Check the function name
Click the cell and read the formula slowly. The most common cause is a typo in the function name. As you start typing a function, Excel shows a list of matching names — pick it from that list instead of typing it fully, and the spelling is guaranteed correct.
Step 2: Check text and ranges
- Make sure any text inside the formula is wrapped in straight quotation marks: "Paid", not Paid.
- Check that ranges use a colon: A1:A5, not A1;A5 or A1 A5.
- If you used a named range, open Formulas > Name Manager and confirm the name still exists and is spelled the same way.
The #NAME? error is one of a small family of Excel errors. If you also see others, here is how to fix the #VALUE! error, the #REF! error, and the #DIV/0! error.
Frequently asked questions
Why does my VLOOKUP show #NAME?
Almost always a spelling slip — for example "VLOOKP" or "VLOOOKUP". Delete the function name and re-pick VLOOKUP from the list Excel shows as you type, which fixes the spelling automatically.
Why do I get #NAME? when using text in a formula?
Text must be wrapped in straight quotation marks. Excel reads unquoted words as a range or defined name it cannot find, so =IF(A1=Paid,...) fails but =IF(A1="Paid",...) works.
Can a deleted named range cause #NAME?
Yes. If a formula refers to a named range that was renamed or deleted, Excel no longer recognizes the name and returns #NAME?. Recreate the name, or replace it with the actual cell range, in Formulas > Name Manager.