Excel Function

IFERROR

Returns fallback value when formula errors.

IFERROR(value, value_if_error)

Arguments

value

Required

Enter an expression such as comparison or calculation.

value_if_error

Required

Specify the value returned if the formula results in an error.

Practice Preview

show outputs based on conditions. Use IFERROR to Returns fallback value when formula errors. use VLOOKUP(B2,B2:D8,3,FALSE) for value, use "N/A" for value_if_error. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=IFERROR(VLOOKUP(B2,B2:D8,3,FALSE), "N/A")

Practice This Function

Practice in Sequential Mode Back to Function List