Returns the specified value unless it is the #N/A error value, in which case returns the specified alternative value.

Syntax  Copy Code
IFNA( Any value, Any alternative ) → Any

Parameters

value

Required. The argument to check for the #N/A error value.

alternative

Required. The value to return if value is #N/A.

Example

Formula  Copy Code
=IFNA(VLOOKUP("Apples",A1:B10,5),"Not found")

See Also

Function Reference
IF Function
ISNA Function