EXCEL IFERROR Function

IFERROR is an Excel function that returns a custom result when a formula generates an error and a standard result when no error is detected.

Syntax:

=IFERROR(value,value_if_error)

Arguments or Parameters

value : The value, reference, or formula to check for an error
value_if_error : The value to return if an error is found

Note: IFERROR checks for the following errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!

Objective: Find the name of the Employee using Ecode. If Ecode is not available then show No Result.

Step 1:

Type = sign in E3 cell
Type IFERROR Function
use the vlookup function in value argument
Type “,”
Type “No Result”
Type”,”
Close bracket with “)”
Press Enter

Result: The IFERROR function returned “No Result” because ecode 107 was not found in the lookup table.