In article <68105295afa28@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Hi Domenic,

Thanks for reply and your assistance. Cell AB4 does just contain a one or
two digit number.

So, I'm using your second suggestion:
($AB$4&"/"&TEXT($B22,"mmm/yy"))+0

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!