Easy search question

[Barbapapa]

Hello,

My problem will most likely be very simple to solve, but I can't figure out anything atm...

I have data as follows

........A..............B.............C......................H..........I
1....name 1....name 2.....name 3....etc...max....winner
2......30...........28..............50.................50
3......60...........11..............27.................60
4 ...

What should I put on the column I so I it shows the winner based on the max result?

Thanks in advance!

 

[Richard Schollar]

If there's only 1 winner, then maybe:

=INDEX($A$1:$G$1,Match(H2,A2:G2,0))

Richard

 

[Barbapapa]

Thanks,

Works great.