IFERROR can gracefully catch any error and return an alternative result .
Trapping the #N/A error with IFNA
TheIFNA functioncan also trap and handle #N/A errors specifically.
The IFERROR function, on the other hand, will catch any error.
For example, even if you spell VLOOKUP incorrectly, IFERROR will return “Not found”.
Based on the example above, the formula in F5 would be:
Read and MATCH.
error
How to fix the #REF!
error
How to fix the #NAME?
error
How to fix the #VALUE!
error
How to fix the #NUM!
error
How to fix the #NULL!
error
How to fix the #CALC!
IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.
MATCH supports approximate and exact matching, andwildcards(* ?)
Often, MATCH is combined with the…
Related videos
Excel formula error codes
