IFNA function
IFNA returns the value that you specify if the expression returns the #N/A error value. Otherwise, returns the result of the expression.
Syntax
IFNA(value,value_if_na)
- value is the argument that is checked for the #N/A error.
- value_if_na is the value to return if the expression evaluates to the #N/A error.
Note:
- If value or value_if_error is an empty cell, IFNA treats it as an empty string value ("").
- If value is an array formula, IFNA returns an array of results for each cell in the range.
Example
=IFNA(VLOOKUP("Formula",A5:B9,1),"not found")
IFNA checks the result of the VLOOKUP function. If Formula is not found in the lookup range, VLOOKUP returns the #N/A value. Then IFNA returns "Not found" in the cell, not the standard #N/A error value.