XLOOKUP with Multiple Criteria

Originally published at: XLOOKUP with Multiple Criteria - Excelbuddy.com

=XLOOKUP(val1&val2&val3,rng1&rng2&rng3,results) val = Lookup Value rng = Lookup Array In order to perform an XLOOKUP with multiple Criteria, you need to concatenate the lookup values and arrays. In our example, this is achieved by using “&” between both the lookup values and arrays. XLOOKUP-Multiple-CriteriaDownload =xlookup(B1&B2&B3,A7:A14&B7:B14&C7:C14,D7:D14) Let’s look at the below using the XLOOKUP function with…

XLOOKUP tutorials on Excelbuddy are constantly being updated. Please check back for more.