Hi JMB,

Thank you very much for your time and assistance. I've tweaked your Formula
slightly and array entered it (Ctrl+ Shift + Enter).

=INDEX(A2:A5,MATCH(MAX(INDEX(A2:H5,0,MATCH(MONTH(B 11),MONTH(A1:H1),0))),INDEX
(A2:H5,0,MATCH(MONTH(B11),MONTH(A1:H1),0)),0))

Very much appreciated.

Cheers,
Sam

JMB wrote:
If your table is in A1:H5 with Labels in column A and Jan in column C, you
could try:

=INDEX(A1:A5,MATCH(MAX(C1:C5),C1:C5,0))

If you don't want to hardcode the range for the month (ie C1:C5), you could
try:

=INDEX(A1:A5,MATCH(MAX(INDEX(A1:H5,0,MATCH(B11,A1 :H1,0))),INDEX(A1:H5,0,MATCH(B11,A1:H1,0)),0))

I got #N/A using Formula as it stands. However, this slight tweak & array
entered works for me.

=INDEX(A2:A5,MATCH(MAX(INDEX(A2:H5,0,MATCH(MONTH(B 11),MONTH(A1:H1),0))),INDEX
(A2:H5,0,MATCH(MONTH(B11),MONTH(A1:H1),0)),0))

where B11 contains the month (Jan) .

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200702/1