Home |
Search |
Today's Posts |
#1
|
|||
|
|||
really need some help on this lookup
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 |
#2
|
|||
|
|||
oops forgot to post my formula** {=INDEX(B30:B35,MATCH(AND(D30:D35=2,E30:E35=1),1)) } -- 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 |
#3
|
|||
|
|||
see replies in .Functions
Biff "chrisrowe_cr" wrote in message news:chrisrowe_cr.1sp56b_1122246302.6724@excelforu m-nospam.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup more than one cell | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |