# #NAME? "Unknown function" in Google Sheets: fix the misspelled function name

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

1. New blank sheet. In A1 type `sku`, B1 `name`. A2 `101`, B2 `Widget`. D2 `101`.
2. In E2 enter:

```plaintext
=VLOKUP(D2,A2:B2,2,FALSE)
```

E2 shows #NAME? with *Unknown function: ‘VLOKUP’*.

3. In F2 enter the same formula with the correct spelling:

```plaintext
=VLOOKUP(D2,A2:B2,2,FALSE)
```

F2 returns `Widget`. Leave E2 broken so the #NAME? stays visible.

4. 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 `D2` and `A2:B2` still 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 turn `VLOKUP` into a function.
- **Don't wrap it in IFERROR.** The name is wrong. Fix the name.

---

*Originally published on* [*SheetError*](https://sheeterror.com/tutorials/name-error/)*, a free library of Google Sheets error fixes (I run it).*

*This article was created with the help of AI.*
