IFNA

Tests whether a value is #N/A and returns a specified value if true, or the original value if false.

Parameter List

Syntax
IFNA(valuevalue_if_na)
value

The expression or cell reference to test for #N/A error. For example: VLOOKUP("key",A1:B10,2,FALSE), A1, or any formula that might return #N/A.

value_if_na

The value to return if the first argument evaluates to #N/A. For example: "Not Found", 0, "", or any alternative value.

More details

IFNA is specifically designed to handle #N/A errors, which are commonly returned by lookup functions when a value is not found. Unlike IFERROR, IFNA only catches #N/A errors and lets other error types pass through unchanged. This makes it ideal for providing default values when lookups fail to find matches.

Examples

IFNA() returns 1