Errors
What Google Sheets formula errors mean and how to fix them: parse errors, #REF!, #VALUE!, #N/A, INDEX MATCH and IMPORTRANGE problems, each one reproduced.
-
#VALUE! Error in Google Sheets: 8 Causes and How to Fix Them
#VALUE! means a function received a value of the wrong type, almost always text where it expected a number. The good news is that Google Sheets tells you exactly which…
-
INDEX MATCH Not Working in Google Sheets: 9 Causes and Fixes
INDEX MATCH looks up a value in one column and returns the matching value from another. When it fails, it fails in two ways: with an error such as #N/A…
-
IMPORTRANGE Not Working in Google Sheets: Every Error and Fix
IMPORTRANGE copies a range from one Google Sheets file into another. It has two arguments, and both must be text: the file’s URL or ID, and the range, including the…
-
How to Replace #N/A with a Blank in Google Sheets (IFNA vs IFERROR)
To show a blank cell instead of #N/A in Google Sheets, wrap the formula in IFNA and use an empty text as the replacement: =IFNA(VLOOKUP(A2, Products!A:C, 3, FALSE), “”) #N/A…
-
#REF! Error in Google Sheets: Every Cause and How to Fix It
#REF! means a formula points to something that doesn’t exist or can’t be used: cells that were deleted, a sheet that isn’t there, a column beyond the end of a…
-
Formula Parse Error in Google Sheets: 9 Causes and a Free Checker
“Formula parse error” means Google Sheets could not read your formula as valid syntax, so it never calculated it. The cell shows #ERROR!, and pointing at it shows the message…