IFNA
Returns the value you specify if the expression resolves to #N/A; otherwise returns the result of the expression
Syntax
IFNA(value, value_if_na)
Parameters
- value: Required. The argument that is checked for the #N/A error value
- value_if_na: Required. The value to return if the formula evaluates to the #N/A error value
Example
=IFNA(VLOOKUP(A1, B:C, 2, FALSE), "Not found")