IFERROR Formula Generator
IFERROR wraps a formula and returns a fallback value when the formula throws an error — #N/A, #DIV/0!, #VALUE!, and so on. Clean dashboards without ugly error cells.
Syntax
=IFERROR(value, value_if_error)Try it — generate a IFERROR formula
Examples
Hide VLOOKUP #N/A with blank
=IFERROR(VLOOKUP(A2, Data!A:B, 2, FALSE), "")If the lookup misses, show empty string instead of #N/A.
Avoid divide-by-zero
=IFERROR(A2/B2, 0)If B2 is 0, return 0 instead of #DIV/0!.
Fallback with helpful message
=IFERROR(INDEX(B:B, MATCH(A2, C:C, 0)), "Not found")Friendly message instead of cryptic error code.
Tips
- ✓IFERROR catches ALL errors. Use IFNA for only #N/A if you want to still see other errors.
- ✓Don't use IFERROR to mask real bugs — wrap only expected errors.
- ✓Available in Excel 2007+ and all Google Sheets.
Related Formulas
VLOOKUP
VLOOKUP searches for a value in the first column of a table and returns a value ...
XLOOKUP
XLOOKUP is the modern replacement for VLOOKUP and HLOOKUP. It can search in any ...
INDEX-MATCH
INDEX-MATCH is a powerful combination that can look up values in any direction —...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free