FUNCTION CATALOGUE / LOGICAL
IFNA Excel function
Returns a fallback when the result is #N/A.
Correct sentence to use
Calculate [expression], or return [fallback] if the result is #N/A.
Modify this query in PlainFormula →Example formula
=IFNA(XLOOKUP(E2,A:A,B:B),"Not found")
Handles #N/A results.
Syntax
IFNA(value, value_if_na)
Argument signature: value, value_if_na
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.