try
=index(name range,match(values range,max(values range)))
"spezialize" wrote:
€¢ Add a column for winner that displays the name of the person with
highest % goal reached.
I have several columsn with names.. and then more columns with
numbers.. once i get the max number i wanna see what name corresponds
with that number..
--
spezialize
------------------------------------------------------------------------
spezialize's Profile: http://www.excelforum.com/member.php...o&userid=28628
View this thread: http://www.excelforum.com/showthread...hreadid=482924