IFNA vs. IFERROR
The IFERROR function works the same as the IFNA function.
However, the only difference is that the IFNA function only identifies and replaces the #N/A error. Whereas the IFERROR function identifies and replaces all kinds of errors that Excel may pose 🧐
For example, let’s nest the above VLOOKUP function in the IFERROR function.
= IFERROR (VLOOKUP (E2, $A$2:$C$6, 3, FALSE), “Missing”)
The results will still be the same.
That’s because the IFERROR function can evaluate all kinds of errors and replace them with the specified text.
So, even if we rewrite the above function as follows:
= VLOOUP (E2, $A$2:$C$6, 3, FALSE)
We have misspelled the VLOOKUP function as VLOOUP. In such a case, Excel returns the #NAME? Error. See for yourself 👀
Now nest it in the IFERROR function as below.
= IFERROR (VLOOUP (E2, $A$2:$C$6, 3, FALSE), “Missing”)
The IFERROR function will replace the #NAME error with the supplied value argument i.e. “Missing” too.
However, if we nest the same formula in the IFNA function, the results would have been different.
= IFNA (VLOOUP (E2, $A$2:$C$6, 3, FALSE), “Missing”)
We still get the #NAME error. That’s because the IFNA function can only handle the #N/A error and no other errors 🤷♀️