=INDEX($B$4:$B$75,MATCH(LARGE($C$4:$C$75,ROW(A1)), $C$4:$C$75,0))

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"owl527" wrote in
message ...

Hi, not only do I want to find the largest number, I actually want to
find the top 5 numbers.
this is what I put:
=("B"&3+MATCH(MAX(C4:C75),C4:C75,0))
I want to get the value in this cell (not the number itself but the
category the number belongs to). it is giving me the cell location, I
am unable to display the value in the cell. How do I do that? PLEASE
HELP! thanks!!!!


--
owl527
------------------------------------------------------------------------
owl527's Profile:
http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=499654