lookup problem

[rich]

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

 

[daddylonglegs]

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

 

[rich]

You are a star, thankyou very much for the rapid reply!