=index(b5;e5,match(max(b6:e6),B6:e6))

You must set MATCH to look for an exact match (match type = 0):
=INDEX(B5:E5,MATCH(MAX(B6:E6),B6:E6,0))
since B6:E6 is not necessarily in ascending order

Do note that in the event of ties in the maximum scores,
the expression will return only the leftmost candidate name

If above helped in any way, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Shone33" wrote:
i want to try this again. I am trying to determine a winner for each county.
In b5:e5 I have my canidates. In column A6:a139 i have my counties, B6:E6 i
have the votes for each canidate. in G6 i have my total votes, and in H6 i
need to input the winner by name using a formula. I tried
=index(b5;e5,match(max(b6:e6),B6:e6)) that gave me the person with the least
votes and i need the highest votes. Please tell me what am i doing wrong.