Tutorials

Short pages on spreadsheet errors and formulas. Posts marked stub are outlines only.

• Stub#REF! after you delete a cell
• Fix IMPORTRANGE #REF! in Google Sheets (You need to connect these sheets)
• 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