Welcome Guest [Log In] [Register]
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:

Username:   Password:
Add Reply
Retrieving an Item from a List that Meets Multiple
Topic Started: Dec 28 2006, 06:57 PM (139 Views)
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins
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)))}

Offline Profile Quote Post Goto Top
 
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins
Posted Image
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Roshnee · Next Topic »
Add Reply