Google Sheets Function: IFERROR

The IFERROR function returns a value if it is not an error or another value in case of an error.


=IFERROR(value, value_if_error)

Practical Case

The example used for the VLOOKUP function will be our starting point.

The VLOOKUP function here returns the number of points based on the file number entered in cell E2:

google sheets function vlookup iferror

In this case, if the file number is not found, an error is returned:

google sheets function vlookup error iferror

To avoid displaying this error (without the IFERROR function), it would be necessary to use the IF function along with a second function to check if there is an error and then return the result of the VLOOKUP function or another value in case of an error:

google sheets function vlookup if isna iferror

In this case, the VLOOKUP function is present twice, and an additional function had to be added.

The IFERROR function simplifies the formula by testing the value returned by the VLOOKUP function and directly returning this same value if there is no error (or another value in case of an error):

google sheets function vlookup iferror
If needed, you can copy the Google Sheets document (or view the document) with this example.