Hi Dili, I appreciate you taking the time to help.

The month cells at top (Q6-AB6), and the Year cells at side (P7-P10), combine to form a month / year table.
The year starts at April 2012, thus reading across the table Dec 2012 leads onto Jan 2013 (Y7-Y8).
Thus Z8 is actually Jan 2014, so that a date of Jan 2013 'should' show up in Z7.

I know these tables do not make much sense but this is the exact format that I have to submit the data in.
It is time consuming trying to collate all this by hand, so I figured this spreadsheet would be the best answer. Thought I had it right too, until Jan this year...

How do we tweak the formula to place the result in Z7? Have I just got the position wrong?

Cheers
Hojo