Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to hide #N/A and other formula errors in Excel and Google Sheets
Topic:IF, IFS & nested conditionsExcel & Google Sheets
=IFERROR(VLOOKUP(D2, A:B, 2, FALSE), "Not found")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Wrap your existing formula in IFERROR( … , "value if error").
- 2The formula runs first; only if it errors does the fallback show.
- 3Use "" as the fallback to leave the cell blank instead of showing an error.
Tips
- Use IFNA instead of IFERROR when you only want to catch #N/A and still see real errors like #REF!.
- Hide errors only after you understand them — IFERROR can mask a genuine problem you should fix.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What is the difference between IFERROR and IFNA?
IFERROR catches every error type; IFNA catches only #N/A. IFNA is safer because it won’t hide a real #REF! or #VALUE! you need to know about.
More on IF, IFS & nested conditions
See all →How-to
How to return a value if a cell contains text
Check if a cell contains specific text with IF + ISNUMBER + SEARCH and return any value you want — plus case-sensitive checks, multiple keywords, and wildcard alternatives.
Error fixFix Nested IF
Nested IF formulas not working in Excel and Google Sheets — fix bracket mismatches, wrong evaluation order, overlapping conditions, and the 64-nesting limit.
How-toHow to return blank instead of zero
Stop formulas showing 0: wrap them in IF to return an empty string, suppress zeros with a custom number format, or hide them sheet-wide — plus the VLOOKUP-returns-0 fix.
How-toHow to sum if a cell contains specific text
Use SUMIF with wildcard criteria (*text*) to sum values in a column whenever a related column contains a specific substring.
How-toHow to write a nested IF formula
Chain multiple IF functions inside each other to test several conditions and return different results for each scenario.
How-toHow to write an IF with multiple conditions
Combine IF with AND or OR to test multiple conditions simultaneously and return a result based on whether all or any are true.