obtainting data based on cell values

[sdtsdt]

hi guys

im trying to do this but not succeeding.
whatever the highest number in cell a6 or b6 needs to return the team name in that column in this case bournemouth into cell d6
see attachment if required
thanks in advance

[Glenn Kennedy]

Many ways to do this. Here's one

=INDEX(A5:B5,,MATCH(MAX(A5:B5),A5:B5,0))

[sdtsdt]

glenn thank you for your reply but that doesnt return the team i want it too

[sdtsdt]

its ok glenn.
tweaked and it works
=INDEX(A2:B2,,MATCH(MAX(A6:B6),A6:B6,0))

[sourabhg98]

Hello
Try this formula
=INDEX(A2:B2,1,MATCH(MAX(A5:B5),A5:B5,0))

This formula would search for the highest value in 5th row and then would give the column no. where the max value if found....at the last it would give the team name in from row 2 where the max value if found....

Tell me if it works right….

Hope it helps
Do ask for any other query you may have…

If you are satisfied then mark then PLEASE mark this thread as “SOLVED” (by going to thread tools at the top and clicking on “mark this thread as solved”) and you can just click on ADD REPUTATION below my post to say thanks...

Regards
Sourabh Gupta