Tip Printed from ExcelTip.com

---

Retrieving a Price from a List that Matches both Category and Item Criteria


Problem:

Columns A:C contain the prices of various items in different categories.
We want to retrieve the price matching each category/item pair shown in columns E & F.
Solution:

Use the INDEX and MATCH functions as shown in the following Array formula:
{=INDEX($C$2:$C$6,MATCH(E2&F2,$A$2:$A$6&$B$2:$B$6,0))}