Hlookup that gives heading as the answer

[bat18]

Hi,

I have a set of data that has names down the left hand side and countries across the top. I can find the max number for each name easily enough but i want to find which country this appears in.

Name USA UK Sweden
John 5000, 60, 100
Dave 1001, 23, 1000
Thom 8000, 50, 27000

So in column 5 i want the answer for John to be USA, David to be USA and Thomas to be Sweden.

Any ideas would be great

Cheers

 

[VoG]

Hi. Try

=INDEX(B$1:D$1,MATCH(MAX(B2:D2),B2:D2,0))

 

[njimack]

=index($b$1:$d$1,match(max(b2:d2),b2:d2,0))

 

[bat18]

Thanks very much