Intermediate
Logical
IFNA
Returns a fallback value only if a formula results in the #N/A error specifically, otherwise returns the formula's normal result (including other error types).
Compatibility: Excel 2013 and later
Syntax
=IFNA(value, value_if_na)
Example
=IFNA(VLOOKUP(A2,B:C,2,FALSE),"Not Found")
When to Use It
Use IFNA instead of IFERROR when you only want to catch a genuine "not found" result from a lookup, while still letting other, more serious errors surface visibly rather than being silently hidden.