Excel format issue

I presume you intend to pull up values based on month and Option in column A of SheetA.

Try using the below

=INDEX(A!$A:$GH,MATCH(B2,A!A:A,0),MATCH(A2,A!1:1,0)) in Cell C3 of SheetB and drag down all the way!

Hi guys thanks for the replies, I have realised that the way I presented the question wasn't quite as I intended, the attached file shows it a bit clearer, hopefully it makes sense and again it is from the top table to the bottom one.Excel test v2.xlsx