In your Formula where you referenced MONTH twice, should one be referenced
DAY?

No. MATCH returns the relative position.

Since your DAY headers are sorted ascending *and* your month headers are
also sorted ascending we only need to find the relative position of the
month.

For the Numeric Label to be returned from Row "4", Column "C" - "AO" does
this range need to be explicitly referenced?

Again, no, for the same reason as stated above. We only need to find the
relative position of the DAY and, since they're sorted ascending we don't
actually need to reference that physical range.

Here's a sample file based on your posted data:

Sam.xls 14kb

http://cjoint.com/?cuu20MDM1I

Biff

"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:6e19f88bf0bc4@uwe...
Hi Biff,

Thanks for reply and assistance.

Unfortunately, I'm not getting the expected result.
In your Formula where you referenced MONTH twice, should one be referenced
DAY?
For the Numeric Label to be returned from Row "4", Column "C" - "AO" does
this range need to be explicitly referenced?

Further help appreciated.

Cheers,
Sam



T. Valko wrote:
Try this:

A1 = lookup_date

=MATCH(MAX(INDEX(C5:H8,MONTH(A1),)),INDEX(C5:H8, MONTH(A1),),0)

Biff

--
Message posted via http://www.officekb.com