=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))

--
Kind regards,

Niek Otten

"fastballfreddy" wrote in message
news:fastballfreddy.27gaxm_1147028100.846@excelfor um-nospam.com...
|
| I have 10 cells w/ various amounts of numbers. I want a formula to find
| the max number and instead of showing that amount, have it show the name
| that goes w/ that amount. Do I use the IF and MAX function?
|
| names in A1, A2, A3 and so on
| numbers in B1,B2,B3 and so on
|
| thanks,
|
|
| --
| fastballfreddy
| ------------------------------------------------------------------------
| fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
| View this thread: http://www.excelforum.com/showthread...hreadid=539672
|