Excel #NAME? error: unknown function or name
Usually a typo or a formula in the wrong language. Here's how to fix #NAME? quickly.
The message you see
#NAME?Fastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- The function name is misspelled.
- An English formula (VLOOKUP) was pasted into Dutch Excel (VERT.ZOEKEN), or the reverse.
- Text inside the formula isn't in double quotes.
- The function doesn't exist in your Excel version (e.g. XLOOKUP in Excel 2016).
How to fix it
- 1Retype the function and pick it from the autocomplete list.
- 2Translate the function name to your Excel language.
- 3Put text values in quotes: =IF(A1="yes",1,0).
- 4Use an older alternative (INDEX/MATCH) if the function is missing.
Related guides
Excel
“Excel cannot open the file because the file format or file extension is not valid”
ExcelExcel error “SYLK: File format is not valid” when opening a CSV
Excel“We found a problem with some content” — Excel workbook won't open properly
Still stuck? Ask SheetFix Support