Parameter List
Syntax
IFNA(value, value_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.