"Don Guillett" wrote in message
...

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

I looked but couldn't figure out how to apply what I found. I found some
other help on using names in formulas, but not how to make a column name
appear in a cell as the result of a formula, as in the example I gave. That
is, if the cell gives the maximum sales in a month of any person as 9, and
those 9 sales were made by the person, John, in the column headed by "John",
how do I make the cell next to the number 9 say "John"?

Ken