#NAME? "Unknown function" in Google Sheets: fix the misspelled function nameYou 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 it3 min read·sheeterror.hashnode.dev2d ago
FILTER "No matches are found" #N/A in Google Sheets: two causes, read the tooltip first=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 for3 min read·sheeterror.hashnode.dev6d ago
IMPORTRANGE #REF! "You need to connect these sheets" in Google Sheets: click Allow access, then read the tooltipYou 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 to3 min read·sheeterror.hashnode.devNov 10
Formula parse error in Google Sheets after pasting a formula: commas vs semicolonsYou 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 separat2 min read·sheeterror.hashnode.devNov 7
#DIV/0! "Function DIVIDE parameter 2 cannot be zero" in Google Sheets: blank cells count as zero=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 302 min read·sheeterror.hashnode.devNov 4