This feature can be used tonestone XLOOKUP inside another to perform a two-way lookup.

The inner XLOOKUP returns a result to the outer XLOOKUP, which returns a final result.

Note: XLOOKUP performs an exact match by default, so match mode is not set.

Excel formula: XLOOKUP basic exact match

Frantz appears in the fifth row, so XLOOKUP returns the fifth row ofdata(C5:E13).

Without named ranges

The named ranges used in this example are for readability only.

However, the XLOOKUP version shows off the power and flexibility of XLOOKUP.

Excel formula: XLOOKUP basic approximate match

XLOOKUP supports approximate and exact matching, wildcards (* ?)

you’ve got the option to use INDEX to retrieve individual values, or entire rows and columns.

MATCH supports approximate and exact matching, andwildcards(* ?)

Excel XLOOKUP function

Often, MATCH is combined with the…

Excel INDEX function

Excel MATCH function