Excel XLOOKUP function

Summary

The Excel XLOOKUP function performs lookups in vertical or horizontal ranges. It is a more robust and flexible successor to older functions like VLOOKUP, HLOOKUP, and LOOKUP.  XLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches.

Syntax
=XLOOKUP (lookup, lookup_array, return_array, [not_found], [match_mode], [search_mode])
XLOOKUP - basic exact match example

Leave a Reply

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