Have a look in the help index for MATCH and then INDEX

--
Don Guillett
SalesAid Software

"KenV" wrote in message
...
It's difficult to explain my question, but I'll try.

Example:

I have a spreadsheet with column headings of names of people and rows with
names of each of the 12 months for a particular year.

In each cell is the number of sales made by each person each month.

At the end of each "month" row I have a cell in which I calulate by
formula, for example, =MAX(B18:M18), the maximum number of sales for that
month by a particular person, say, John. IOW, it is a cell that gives the
maximum number of sales made by any one person that month. No problem
there. But either in that cell, or in another cell next to it, I want to
automatically place the /name/ of the person in the column heading who
made the maximum number of sales for that month. How do I do that? It
probably is simple, but I don't know the answer.

Thanks very much.

Ken