| Assalamoalaikum, We hope you will enjoy your visit here. Join our community! If you're already a member please log in to your account to access all of our features: |
| Retrieving an Item from a List that Meets Multiple | |
|---|---|
| Tweet Topic Started: Dec 28 2006, 06:57 PM (139 Views) | |
| Ahmaq | Dec 28 2006, 06:57 PM Post #1 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
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 < D3)))} |
![]() |
|
| Ahmaq | Dec 28 2006, 06:57 PM Post #2 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
Posted Image |
![]() |
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · Roshnee · Next Topic » |








5:33 AM Jul 11