Excel Version: 2021, 365
The Excel XLOOKUP function is a modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP.
XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges.
Example of use
Here is another simple example of use. Overcoming the limitations of the most commonly used VLOOKUP function is enabled by specifying the column from which we need feedback, in this case it is column D3: D10. If we need information from column A (ordinal number) only instead of the parameter D3: D10 we need to put B3: B10.
It is extremely easy to use. I pushed the domino. As a result, it fell over.
Syntax
=XLOOKUP (lookup, lookup_array, return_array, [not_found], [match_mode], [search_mode])
- lookup – The lookup value.
- lookup_array – The array or range to search.
- return_array – The array or range to return.
- not_found – [optional] Value to return if no match found.
- match_mode – [optional] 0 = exact match (default), -1 = exact match or next smallest, 1 = exact match or next larger, 2 = wildcard match.
- search_mode – [optional] 1 = search from first (default), -1 = search from last, 2 = binary search ascending, -2 = binary search descending.