Tip Printed from ExcelTip.com

---

Retrieving an Item from a List that Meets Multiple Criteria


Problem:

Range1 (A3:C7) contains file names with their matching types and sizes.
Range2 (A12:B16) contains a similar list of file names but with matching types only.
We want to find the appropriate file sizes from Range1 by matching each pair of file names and types from both ranges.

Solution:

Use the INDEX and MATCH functions as shown in the following Array formula:
{=INDEX($C$3:$C$7,MATCH(A12&B12,$A$3:$A$7&$B$3:$B$7,0))}