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