really need some help on this lookup

[chrisrowe_cr]

Hi all,

I have still not managed to my formula working. The folling data is on one workbook.

Product Type.........Risk Val.......Rating
Surfing........................2...............2
Racing.........................2...............1
Skiing..........................2...............6
Diving..........................3...............3
Rallying.......................2................5
Bungee Jumping..........3...............4

if the prod type is in A2:A7, the risk val is B2:B7 and the rating in C2:C7 im trying to look up the product name of the highest ranked product with a risk val of 2. For instance, in my second workbook I would want to look up RACING. I want to be able to repeat this process to look up the next highest and so on with SURFING next followed by RALLYING. You'll notice that the items with a higher risk value are to be ignored. I desperatly need to get this done, much appreciate any help. Chris.

[chrisrowe_cr]

oops forgot to post my formula** {=INDEX(B30:B35,MATCH(AND(D30:D35=2,E30:E35=1),1))}

[Biff]

see replies in .Functions

Biff

"chrisrowe_cr" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi all,
>
> I have still not managed to my formula working. The folling data is on
> one workbook.
>
> Product Type.........Risk Val.......Rating
> Surfing........................2...............2
> Racing.........................2...............1
> Skiing..........................2...............6
> Diving..........................3...............3
> Rallying.......................2................5
> Bungee Jumping..........3...............4
>
> if the prod type is in A2:A7, the risk val is B2:B7 and the rating in
> C2:C7 im trying to look up the product name of the highest ranked
> product with a risk val of 2. For instance, in my second workbook I
> would want to look up RACING. I want to be able to repeat this process
> to look up the next highest and so on with SURFING next followed by
> RALLYING. You'll notice that the items with a higher risk value are to
> be ignored. I desperatly need to get this done, much appreciate any
> help. Chris.
>
>
> --
> chrisrowe_cr
> ------------------------------------------------------------------------
> chrisrowe_cr's Profile:
> http://www.excelforum.com/member.php...o&userid=25220
> View this thread: http://www.excelforum.com/showthread...hreadid=389757
>