Therefore, when using multiple expressions, a lookup value of 1 makes sense.
XLOOKUP supports approximate and exact matching, wildcards (* ?)
for partial matches, and lookups in vertical or horizontal ranges….
XLOOKUP with logical criteria
To use XLOOKUP with multiple logical, build expressions with boolean logic and then look for the number 1. In the example shown, XLOOKUP is used to look up the first sale to Chicago over $250. The formula in G6 is: =XLOOKUP(1,(D5:D14="chicago")*(E5:E14>250),B5:B14) which returns 0347, the order number of the first record that meets the supplied criteria. Note: XLOOKUP is not case-sensitive.
