XLOOKUP – Excel Function

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])

Leave a Reply

Your email address will not be published. Required fields are marked *