---
title: "SheetError (@sheeterror) | Hashnode"
description: "Plain-English fixes for Google Sheets and Excel errors. Guides at sheeterror.com. Read the latest articles by SheetError on Hashnode."
url: "https://hashnode.com/@sheeterror"
---

@sheeterror

# SheetError

@sheeterror · Joined October 2026

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

### [#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

3 min read · [sheeterror.hashnode.dev](https://sheeterror.hashnode.dev/name-unknown-function-in-google-sheets-fix-the-misspelled-function-name?utm_source=hashnode&utm_medium=feed)

[2d ago](https://hashnode.com/posts/name-unknown-function-in-google-sheets-fix-the-misspelled-function-name/6afa8f49ec731951ec7b7206)

### [FILTER "No matches are found" #N/A in Google Sheets: two causes, read the tooltip first](https://sheeterror.hashnode.dev/filter-no-matches-are-found-n-a-in-google-sheets-two-causes-read-the-tooltip-first?utm_source=hashnode&utm_medium=feed)

\=FILTER(...) comes back as #N/A. The key you wanted might be missing, or it might be sitting right there. Both look like #N/A. The tooltip is what tells them apart. Why it happens FILTER uses #N/A for

3 min read · [sheeterror.hashnode.dev](https://sheeterror.hashnode.dev/filter-no-matches-are-found-n-a-in-google-sheets-two-causes-read-the-tooltip-first?utm_source=hashnode&utm_medium=feed)

[6d ago](https://hashnode.com/posts/filter-no-matches-are-found-n-a-in-google-sheets-two-causes-read-the-tooltip-first/6af530c2c6ace04af82917bf)

### [IMPORTRANGE #REF! "You need to connect these sheets" in Google Sheets: click Allow access, then read the tooltip](https://sheeterror.hashnode.dev/importrange-ref-you-need-to-connect-these-sheets-in-google-sheets-click-allow-access-then-read-the-tooltip?utm_source=hashnode&utm_medium=feed)

You write =IMPORTRANGE(...) to pull a range from another spreadsheet and the cell shows #REF!. The URL is right, the range is right, and the tab exists. Hover the cell and the tooltip says You need to

3 min read · [sheeterror.hashnode.dev](https://sheeterror.hashnode.dev/importrange-ref-you-need-to-connect-these-sheets-in-google-sheets-click-allow-access-then-read-the-tooltip?utm_source=hashnode&utm_medium=feed)

[Nov 10](https://hashnode.com/posts/importrange-ref-you-need-to-connect-these-sheets-in-google-sheets-click-allow-access-then-read-the-tooltip/6af27b689f97831e0a141277)

### [Formula parse error in Google Sheets after pasting a formula: commas vs semicolons](https://sheeterror.hashnode.dev/formula-parse-error-in-google-sheets-after-pasting-a-formula-commas-vs-semicolons?utm_source=hashnode&utm_medium=feed)

You paste a VLOOKUP from a tutorial and the cell shows #ERROR!. The tooltip says Formula parse error. The function name is spelled right. The problem is the commas. Why it happens The argument separat

2 min read · [sheeterror.hashnode.dev](https://sheeterror.hashnode.dev/formula-parse-error-in-google-sheets-after-pasting-a-formula-commas-vs-semicolons?utm_source=hashnode&utm_medium=feed)

[Nov 7](https://hashnode.com/posts/formula-parse-error-in-google-sheets-after-pasting-a-formula-commas-vs-semicolons/6aeeb478b56e59a22891fc90)

### [#DIV/0! "Function DIVIDE parameter 2 cannot be zero" in Google Sheets: blank cells count as zero](https://sheeterror.hashnode.dev/div-0-function-divide-parameter-2-cannot-be-zero-in-google-sheets-blank-cells-count-as-zero?utm_source=hashnode&utm_medium=feed)

\=A2/B2 shows #DIV/0! and the tooltip says Function DIVIDE parameter 2 cannot be zero. Often B2 isn't even a zero. It's empty. In arithmetic, Google Sheets treats a blank cell as 0. Reproduce it in 30

2 min read · [sheeterror.hashnode.dev](https://sheeterror.hashnode.dev/div-0-function-divide-parameter-2-cannot-be-zero-in-google-sheets-blank-cells-count-as-zero?utm_source=hashnode&utm_medium=feed)

[Nov 4](https://hashnode.com/posts/div-0-function-divide-parameter-2-cannot-be-zero-in-google-sheets-blank-cells-count-as-zero/6aeaa384ef5fa3c93731950b)
