IFNA
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.
LogicalError Handling & ChecksLogic & ConditionsMost Used
What it does
Returns a fallback value when a formula returns #N/A; otherwise returns the formula result.
Syntax
IFNA(value, value_if_na)
Arguments
value(value) — Expression to evaluate.value_if_na(value) — Returned if value is #N/A.
Examples
Handle not-found
Return "Missing" if MATCH returns #N/A.
FORMULA
=IFNA(MATCH(A2,B2:B5,0),"Missing")
RESULT
Missing
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Value to find | List |
| 2 | K9 | A1 |
| 3 | B2 | |
| 4 | C3 | |
| 5 | D4 |