In Microsoft Excel, if the inputs are not valid, then the forula 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 formulas to avoid the error.
If you put the following vlookup formula and the vlookup 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.
Alternatively we can also use “IFERROR” which is simple as comparted to “ISERROR”.