Try this:

A1:A10 = names
B1:B10 = sales figures

To get the name with the highest sales:

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

--
Biff
Microsoft Excel MVP


"Excellerated" wrote in message
...
I need to have a cell give a name of a person who has the most sales. there
is a column with the names of the people and another with the vales or
totals. I am told I can use the IF and MAX function, but I must use them
several times in the same formula to do this. I can use them separately,
but
I don't know how to use them together.