INDEX and MATCH with multiple criteria - Excel formula | Exceljet
https://exceljet.net/formulas/index-and-match-with-multiple-criteria
Web ResultINDEX. MATCH. Download Worksheet. Summary. To lookup values with INDEX and MATCH, using multiple criteria, you can use an array formula. In the example shown, the formula in H8 is: = INDEX (E5:E11, MATCH (1,(H5 = B5:B11) * (H6 = C5:C11) * (H7 = D5:D11),0)) The result is $17.00, the Price of a Large Red T-shirt.
DA: 51 PA: 87 MOZ Rank: 89