Share this article:

What it does: The XLOOKUP() Function allows you to look up and return values in corresponding columns or rows (!!). I have an exclamation point there because in many ways this function could eliminate most of the need for Vlookup, Hlookup, and the Index/Match combination when used for that purpose.

Arguments: XLOOKUP(lookup_value, lookup_array, return_array, [match_mode], [search_mode])