lookup help

[Ted Metro]

I have a table that looks like this --

jan feb mar
customer a 5 3 2
customer b 6 4 9

I want to write a formula that will show which month produced the highest
value. So for customer a the formula would produce january, and for customer
b, the formula will produce march.

Thanks!

Ted

 

[Mangus Pyke]

jan feb mar
customer a 5 3 2
customer b 6 4 9

Assuming that the months are in row 1
and the customers are in column A:

=INDEX(1:1,MATCH(MAX(B22),B22,0)+1)

Expand your range (i.e. B22) to include the monthly ranges and then
drag down so that they include the remaining customers (i.e. C22 and
C33)..

HTH,

MP-