IFNA catches specifically the #N/A error and replaces it with something else — more targeted than IFERROR, which catches every error type.
IFNA checks if a formula results in the #N/A error specifically — the error VLOOKUP, MATCH, and XLOOKUP throw when nothing matches — and returns a fallback value if so.
Unlike IFERROR, it lets other error types (like #DIV/0! or #VALUE!) through unchanged, so you only mask the specific "not found" case rather than hiding every possible mistake.
=IFNA(value, value_if_na)| Argument | Description |
|---|---|
| value required | The formula or value to check. |
| value_if_na required | What to return if value evaluates to #N/A. |
=IFNA(VLOOKUP(A2,B:C,2,FALSE),"Not found")If the VLOOKUP fails to find A2, this shows "Not found" instead of #N/A — but other errors, like a malformed range, would still display normally.
=IFNA(MATCH(A2,B:B,0),0)Useful when a missing match should be treated as a count of zero, not break a downstream formula.
=IFNA(XLOOKUP(A2,B:B,C:C),"No match")XLOOKUP also returns #N/A when nothing matches, so IFNA works the same way here.
| Situation | Use |
|---|---|
| Only want to catch "not found" lookups | IFNA |
| Want to catch every possible error type | IFERROR |
IFERROR is more forgiving but can accidentally hide real mistakes — like a #DIV/0! caused by a genuine formula bug — by quietly replacing them with your fallback value. IFNA is more precise and safer when you only expect "not found" to be a normal, acceptable outcome.
If you genuinely want to hide all error types, not just #N/A, use IFERROR instead.
ExcelPro has 700+ hands-on Excel exercises across 7 career tracks — free to start, no download needed.
Start practicing free →