Locating a cell address

[MikeB]

Let's say I have a table:

Month Usage
Jan 10
Feb 12
Mar 14
Apr 16
May 14
Jun 18
Jul 12
Aug 8

etc.

If I use the "Max" function to obtain the value for Jun, is there some
way that I can obtain the corresponding value for the cell containing
"Jun", so I can have a summary as follows:

Max: 18 (Jun).

Hope that's clear.

Thanks.

 

[Ragdyer]

With months in A2 to A9, and values in B2 to B9, try this:

=INDEX(A2:A9,MATCH(MAX(B2:B9),B2:B9,0))

If you have duplicate max values, this formula will return the month of the
*first* max value.