You type what looks like a normal VLOOKUP and the cell shows #NAME?. The tooltip says Unknown function: ‘VLOKUP’. The ranges are fine. The formula never ran. Sheets doesn't recognize the name.
Why it happens
#NAME? means a name in the formula isn't a function, a named range, or a named function on this spreadsheet. One missing letter is enough: VLOKUP is not VLOOKUP, and Sheets does not fuzzy-match function names. A bare word like =Hello is also read as a name. Named functions and named ranges are local to the file, so a formula pasted from another spreadsheet can bring a name that doesn't exist here.
Reproduce it in a minute
- New blank sheet. In A1 type
sku, B1name. A2101, B2Widget. D2101. - In E2 enter:
=VLOKUP(D2,A2:B2,2,FALSE)
E2 shows #NAME? with Unknown function: ‘VLOKUP’.
- In F2 enter the same formula with the correct spelling:
=VLOOKUP(D2,A2:B2,2,FALSE)
F2 returns Widget. Leave E2 broken so the #NAME? stays visible.
- Optional second case: in G2 enter
=Hello. That's also #NAME?. In H2 enter="Hello". Quotes make a string, and H2 shows Hello.
The fix
Correct the name. Change VLOKUP to VLOOKUP, or keep E2 as the broken example and use F2 as the working copy. Function names in Google Sheets are not case-sensitive (=vlookup(...) is fine), but spelling is not optional. IFNA is not IFNAA.
For a bare word, quote it (="Hello") or call a real function (=UPPER("Hello")). Don't leave an unquoted identifier unless it's a defined named range.
For a name you brought from another file: Data > Named functions to define or import it, or Data > Named ranges to create the range, or replace it with a normal range like A2:B2.
Watch out for
- It's not a Formula parse error. A parse error is #ERROR! when argument separators don't match the locale (commas vs semicolons). The function name can be spelled correctly and still fail to parse. On this recreate the tooltip says Unknown function, and F2 with the same commas returns Widget.
- It's not #N/A. #N/A means the function ran and found no match. E2 never got that far.
-
It's not #REF!. The ranges
D2andA2:B2still exist. -
Locale won't invent a typo. Sheets function names stay English (
VLOOKUP,SUM,IF) even when the UI isn't. Changing File > Settings > Locale will not turnVLOKUPinto a function. - Don't wrap it in IFERROR. The name is wrong. Fix the name.
Originally published on SheetError, a free library of Google Sheets error fixes (I run it).
This article was created with the help of AI.
Top comments (0)