|  

» Retrieving an Item from a List that Meets Multiple Criteria

Problem:

Range A2:C7 contains a list of items and their corresponding colors and prices.
We want to find the name of the first Blue item that costs less than $200.

Solution:
Use the INDEX and MATCH functions as shown in the following Array formula:
{=INDEX(A2:A7,MATCH(1,(B2:B7=D2)*(C2:C7
Example:

Item______Color____Price___Criteria
Shoes_____Red______$140____Blue
Jacket____Brown____$300____$200
Shoes_____Blue_____$199
T-Shirt___Green____$10
Jeans_____Blue_____$150
Shoes_____Black____$99

Result_____Shoes
Screenshot // Retrieving an Item from a List that Meets Multiple Criteria
Retrieving an Item from a List that Meets Multiple Criteria
Rate This Tip
12 34 5
Rating: 3.15     Views: 25815
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments