Excel Function

IFNA

Returns fallback value for #N/A errors.

IFNA(value, value_if_na)

Arguments

value

Required

Enter an expression such as comparison or calculation.

value_if_na

Required

Specify the value returned when #N/A occurs.

Practice Preview

show outputs based on conditions. Use IFNA to Returns fallback value for #N/A errors. use XLOOKUP(B2,B2:B8,D2:D8) for value, use "N/A" for value_if_na. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=IFNA(XLOOKUP(B2,B2:B8,D2:D8), "N/A")

Practice This Function

Practice in Sequential Mode Back to Function List