How to return the text data of the first col after getting the max value from the 2nd col

  • Thread starter Thread starter Joyce
  • Start date Start date
J

Joyce

Hi,

Does anyone have any suggestions on how to do the following?
I have 2 columns, one for months and the other for a number value.
I use the Max function to find the largest number in the second column,
which is 9 here.
My question: is there a function/formula that will return the cell
containing the word "May" based on the results of the Max function?

Jan 6 largest value is 9 for the month of May
Feb 2
Mar 4
Apr 2
May 9
June 3

Thanks.
 
Assume your month names are in column A, and your numbers are in column B:

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

Just change the row and column references to fit your data.
 
Back
Top