Skip to content

DEV Community

SheetError

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

Joined on Oct 27, 2026

SheetError

Nov 12

FILTER "No matches are found" #N/A in Google Sheets: two causes, read the tooltip first

#googlesheets #spreadsheets #productivity #tutorial

2 min read

SheetError

Nov 10

IMPORTRANGE #REF! "You need to connect these sheets" in Google Sheets: click Allow access, then read the tooltip

#googlesheets #spreadsheets #productivity #tutorial

3 min read

SheetError

Nov 7

Formula parse error in Google Sheets after pasting a formula: commas vs semicolons

#googlesheets #spreadsheets #productivity #tutorial

2 min read

SheetError

Nov 4

#DIV/0! "Function DIVIDE parameter 2 cannot be zero" in Google Sheets: blank cells count as zero

#googlesheets #spreadsheets #productivity #tutorial

2 min read

SheetError

Nov 1

ISBLANK is FALSE on a cell that looks empty (and IFBLANK doesn't exist) in Google Sheets

#googlesheets #spreadsheets #productivity #tutorial

2 min read

SheetError

Oct 28

VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces

#googlesheets #spreadsheets #productivity #tutorial

2 min read

SheetError

Oct 27

Fix "Function ADD parameter 2 expects number values" (#VALUE!) in Google Sheets

#googlesheets #spreadsheets #productivity #tutorial

3 min read

loading...