Sheet Error

Google Sheets errors and formulas, explained.

Tutorials

Posts marked stub are outlines only. The rest are walkthroughs you can type into a sheet.

• Stub#REF! after you delete a cell
• Fix VLOOKUP #N/A in Google Sheets (spaces and numbers stored as text)
• Fix VLOOKUP #REF! in Google Sheets (column index bigger than the range)
• VLOOKUP returns the wrong row in Google Sheets (TRUE approximate match)
• StubWhat #N/A actually means in Google Sheets