=MAX / Selection Function problem

[martyloo]

Not a mayjor problem im sure you guys can easily fix it, so here we go......

I have a cell which selects the maximum number in a given range of cells

I want to have a seperate cell which understand where the biggest number is and displays the month that cell is in.

For example i have this

Jan, Feb, Mar, Apr, May
4 3 8 4 9

In two seperate coloums.

So one cell selects the max number in those cells which is "9" I need an other cell to select the month that number 9 is in (May)


Any Ideas????

 

[VoG]

Try

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

assumes months in column A and numbers in column B.

 

[martyloo]

Thanks worked perfectly