Last Match
By default, the XLOOKUP Function performs a top-to-bottom search. But if the user wants to change this order and search for the bottom to top then the formula should be: =XLOOKUP(Search for the value, in this range, return the output from this range, -1)
Note: -1 in this formula should be the 6th parameter)
XLOOKUP Function in Excel With Examples
XLOOKUP Function helps us to search value in a horizontal or vertical dataset and return the relative value in some other row or column. In this article, we will look at the XLOOKUP Function in Excel. XLOOKUP is a modern replacement for functions like HLOOKUP, VLOOKUP, and LOOKUP. XLOOKUP supports approximate and exact matching, wildcards for partial matches, and lookups in horizontal or vertical ranges. XLOOKUP can be performed in Microsoft 365.