Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup problem
Hi,
I have a table that stores 'recipe' values where the 1st row has the column headers (ingredients) the precedding rows have the % assigned to that ingredient. Each row representing a different recipe. What I need to be able to do is to find the ingredient with the highest % in each recipe. I thought I could do this by using the MAX function to find the highest %, then use the HLOOKUP to find what ingredient matched that %, but I'm having problems. Sorry about the bad example below, hope it comes out right as to what I'm tring to achieve! A B C D E MAX LOOKUP 0 0 20 80 0 Max(A2:E2) HLOOKUP(MAX,A1:E5,2) 20 20 20 20 20 Max(A3:E3) " 80 20 0 0 0 Max(A3:E3) " 10 10 10 10 60 Max(A3:E3) " Am I going about this the correct way? Does anyone have any working examples I may use for reference? Any help would be appreciated. Cheers Rich |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup problem
If you have =MAX(A2:E2) in F2 then =INDEX(A$1:E$1,MATCH(F2,A2:E2,0)) copy down column although where you have more than one Max value in a row, e.g. row three, this formula will just give you the header relating to the first match -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=505534 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup problem
You are a star, thankyou very much for the rapid reply!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range Lookup - Problem | Excel Worksheet Functions | |||
Range Lookup - Problem | Excel Worksheet Functions | |||
Range Lookup - Problem | Excel Worksheet Functions | |||
Lookup Problem | Excel Worksheet Functions | |||
Lookup Problem | Excel Worksheet Functions |