---
title: "Discussion on \"#NAME? \"Unknown function\" in Google Sheets: fix the misspelled function name\" | Hashnode"
description: "Discussion on \"#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.\nWhy it"
url: "https://hashnode.com/posts/name-unknown-function-in-google-sheets-fix-the-misspelled-function-name/6afa8f49ec731951ec7b7206"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [#NAME? "Unknown function" in Google Sheets: fix the misspelled function name](https://sheeterror.hashnode.dev/name-unknown-function-in-google-sheets-fix-the-misspelled-function-name?utm_source=hashnode&utm_medium=feed)

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

1d ago · 3 min read · sheeterror.hashnode.dev  
Read the article

-   [#tutorial](https://hashnode.com/tag/tutorial)
-   [#google-sheets](https://hashnode.com/tag/google-sheets)
-   [#spreadsheets](https://hashnode.com/tag/spreadsheets)
-   [#productivity](https://hashnode.com/tag/productivity)

## Written by

[SheetError](https://hashnode.com/@sheeterror)

@sheeterror

  
[View profile](https://hashnode.com/@sheeterror)

Plain-English fixes for Google Sheets and Excel errors. Guides at sheeterror.com

Plain-English fixes for Google Sheets and Excel errors. Guides at sheeterror.com

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
