In Microsoft Excel, if the inputs are not valid, then the formula will show the error. This error may be like, #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.
To avoid this error, you can use the “ISERROR” or “IFERROR” formula. “IFERROR” is simple and easy, but this function is available only in Excel 2007 and above versions.
In this post you can learn how to use these two functions to handle the error in excel formula.
If you put the following vlookup formula and the lookup value is not available in the table, then it will show the error “#N/A” in the cell.
To avoid the error we can use the “ISERROR” formula with “IF” Condition.
Syntax for ISERROR:
value: Value to check in the formula for error.
ISERROR will check the value and return TRUE if it is error and FALSE if it is not an error.
With IF condition we can put ISERROR to hide error in formula as below:
IFERROR function to handle error
Alternatively we can also use IFERROR excel functions which is simple as comparted to “ISERROR”. This function is available in Excel 2007 and above version. This is much simple as compared to ISERROR.
Syntax for IFERROR excel functions:
=IFERROR (value, value_if_error)
value – Value to check in the formula for error.
value_if_error – The output, if an error is found in value.
In this formula, if the vlookup output is error , it will show Not Found instead of error.