Google Sheets #N/A: Decide Whether a Result Is Missing or the Request Is Wrong
#N/A does not always mean the formula is malformed. It can mean a lookup found no match or a filter selected no records. First decide what the formula was supposed to find, then distinguish missing source data from a legitimate empty result.
Start with the question, not the fallback
For a lookup, inspect the search key and the first column of the selected range. Google’s VLOOKUP help documents #N/A when an exact-match key is absent, and warns that leading or trailing spaces make superficially similar keys different. For a filter, Google’s FILTER help documents #N/A when no records satisfy the conditions.
Do not change an exact lookup to approximate matching to make the error disappear. A returned record is useful only if it answers the intended question.
One dataset, two different diagnoses
In a scratch sheet, enter Tea in A2, 8 in B2, Coffee in A3 and 12 in B3. Place test formulas outside A2:B3.
=VLOOKUP("Cocoa",A2:B3,2,FALSE)
Expected: #N/A, because Cocoa is absent. If the intended request was Coffee, correct the key:
=VLOOKUP("Coffee",A2:B3,2,FALSE)
Expected: 12. If Cocoa really is required, do not relabel it Coffee; investigate the missing source record instead.
Now test a different question:
=FILTER(A2:B3,B2:B3>20)
Expected: #N/A, because neither 8 nor 12 exceeds 20. Changing the condition to B2:B3>10 should return the single row Coffee, 12. That is a different question, not automatically a repair. Keep the original threshold if it reflects the report’s requirement.
A deliberate no-results message
After confirming that an empty selection is acceptable, use:
=IFNA(FILTER(A2:B3,B2:B3>20),"No items above threshold")
Expected: No items above threshold. This is a presentation choice, not an invented numeric zero. IFNA handles #N/A specifically; it should not be used to declare every source complete. Retain a raw diagnostic view when the same report depends on required imported data.
If adding rows broke the condition’s dimensions instead, use the FILTER range-size troubleshooting tutorial, not a broader error-suppression formula.
Scope and evidence
Checked October 21, 2026 for the rolling Google Sheets web service and ordinary worksheet formulas, not BigQuery or a paid Connected Sheets workflow. The examples were independently checked against the tiny dataset, not run in a signed-in application; no screenshot is claimed. English names and comma separators are shown. Check the spreadsheet’s locale and function-language settings when adapting formulas; changing settings affects collaborators too.