Hi Domenic,

Thank you very much for explanation and corrected Formula. That's Great!

Cheers,
Sam

Domenic wrote:
Hi Domenic,

[quoted text clipped - 5 lines]

What does the +0 actually do?

That part of the formula returns the date as a text string. The +0 bit
coerces it into a true date value.

Cell AB4 contains the two digit number 31 and the month in B22 is June. It
returns has #N/A. Should it have returned #VALUE as the 31 June does not
exist?

=INDEX(OFFSET(Data,0,0,,10),MATCH($AB$4&"/"&TEXT($B22,"mm/yy")+0,Date,0),
COLUMN(A:A))

Opening and closing brackets for the lookup value have been omitted.
The formula should be as follows...

=INDEX(OFFSET(Data,0,0,,10),MATCH(($AB$4&"/"&TEXT($B22,"mm/yy"))+0,Date,0
),COLUMN(A:A))

Hope this helps!

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