All functions / Logical

IFNA

Returns a fallback value only for #N/A errors.

Syntax

=IFNA(value, value_if_na)

Arguments

• value: The formula to try.
• value_if_na: What to return instead of #N/A.

Example

=IFNA(VLOOKUP(E2, A:B, 2, FALSE), "Not found") → "Not found" for missing items

Practise it

• IFERROR and IFNA