=INDEX(A2:A50,MATCH(MAX(B2:B50),B2:B50,0))

replace A2:A50 with the sales people range and B2:B50 with their sales
amount

--
Regards,

Peo Sjoblom


"Gary" wrote in message
...
I am needing a function that will look at the following and using 'max &
if'
ID the highest salesperson.

George $300
Rita $400
Robert $500

It would be somelike this this: =IF(sales for #1=max,"salesperson #1
name",if(sales for #2=max,"salesperson #2 name", if......

but I'm not able to get it to work. Any suggestions?