How to use XLOOKUP with Multiple Criteria in Excel - Lookup Formula with multi criteria

In this video, I'll show you How to use XLOOKUP with Multiple Criteria in Excel, in other words, how to build a lookup formula with multi-criteria.
🚀 Get the latest Excel tips: https://exceldashboardschool.com/

File: https://excelkid.com/wp-content/uploa...

Let's see the formula to calculate the price where the Item equals the T-Shirt. The size is Large, and the color is blue. First, check the Items column using this formula. If the value is TRUE, the item meets the criteria. Okay, apply a logical test for the size column. As we stated, the item meets the criteria if the value is TRUE. Finally, check the color. Okay, we have boolean values. Use the double negative method to convert boolean values to ones or zeros.
We are using multiplication which works like an end logical operator. If the result is one, we have a matching record. Type XLOOKUP and add the first argument. The lookup value is equal to one. The second argument is the lookup array. We use three logical tests. The last argument is the return array, in this case, the Price column. The result looks great! If you want to list all matching records, use the FILTER function.

Chapters:
00:00 Intro
00:13 How to use XLOOKUP with multiple criteria

#exceltips #exceltutorial #excel