=INDEX(B:B,MATCH(MAX(C:C),C:C,0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Toobi-Won Kenobi" wrote in message
...
I have a sheet that consists of a list of team names in column B.
A running total (provided via VB) in column D which increases by the cell
value inputted into column C.
I would like to be able to find the highest value in column C and display
the corresponding name from column B in another cell. (E,F5?)

TIA

TWK