The goal is to remove the #N/A error that XLOOKUP returns when it can’t find a result.
XLOOKUP function
XLOOKUP is a modern replacement for the VLOOKUP function.
It is a flexible and versatile function that can be used in a wide variety of situations.
However, the alternative value is not limited to text.
In this way, you might chain together multiple XLOOKUP formulas.
The formula above is not wrong, it is just more complex than necessary.
This is a different formula from the IFNA formula above, and different from providing a value for thenot_foundargument.
This formula will trapany errorreturned by XLOOKUP, including #REF!, #NAME, etc.
Unless you have a good reason to want this result, I would avoid XLOOKUP with IFERROR.
XLOOKUP supports approximate and exact matching, wildcards (* ?)
IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.
