IFNA pitfall 1: Catches only the #N/A error; other errors (#REF!, #VALUE!, #DIV/0!) still bubble up?

Catches only the `#N/A` error; other errors (`#REF!`, `#VALUE!`, `#DIV/0!`) still bubble up. That's usually what you want.

IFNA pitfall 2: Most useful right around lookup formulas like VLOOKUP/XLOOKUP/MATCH where #N/A means "not found" rather than a real bug?

Most useful right around lookup formulas like `VLOOKUP`/`XLOOKUP`/`MATCH` where `#N/A` means "not found" rather than a real bug.

Logiceasy

Returns the first argument unless it is the #N/A error, in which case returns the second.

Syntax

=IFNA(value, value_if_na)

Arguments

Argument	Description
value	The value to return if it is not #N/A.
value_if_na	The value to return when value evaluates to #N/A.

Example

=IFNA(VLOOKUP("X", A:B, 2, FALSE), "Not found")

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and IFNA isn't one of them yet.

Catches only the #N/A error; other errors (#REF!, #VALUE!, #DIV/0!) still bubble up. That's usually what you want.
Most useful right around lookup formulas like VLOOKUP/XLOOKUP/MATCH where #N/A means "not found" rather than a real bug.

Related formulas

Used by