Excel Function

ISERROR

Checks whether value is any error.

ISERROR(value)

Arguments

value

Required

Enter an expression such as comparison or calculation.

Practice Preview

show value type/status checks. Use ISERROR to Checks whether value is any error. use VLOOKUP(B2,B2:D8,3,FALSE) for value. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=ISERROR(VLOOKUP(B2,B2:D8,3,FALSE))

Practice This Function

Practice in Sequential Mode Back to Function List