Functions
IFNA
Return alternate value on #N/A
Try it
When to use it
When should I use IFNA instead of IFERROR?
Use IFNA to catch only the #N/A error, which usually means a lookup failed; use IFERROR when you want to catch every kind of error.
Why prefer IFNA over IFERROR for lookups?
IFNA leaves other errors like #DIV/0! visible so real mistakes are not hidden, while still replacing the #N/A from a failed lookup.
Use cases
Replace an #N/A with a fallback word
Default a missing lookup to zero
Used in
Syntax
IFNA(value, value_if_na)Examples
=IFNA(205,"Na error") // => 205
=IFNA(2+3,0) // => 5