Look up Table and transpose to another

Hello everyone,

Hoping to get some help with the attached file. I'm looking to lookup specific data from one table and somehow paste it into another table. I'm thinking you might have to transpose but perhaps it can be achieved using index match formula.

I've colored the associated cells to help guide what data I need where. Please note this is a small subset of data and the tables are much larger than the example.


Thank you in advance for your help

W3=IF($Q3<>"",SUMPRODUCT(($B$3:$B$5=$Q3)*(MONTH($D$2:$O$2&0)=MONTH($S3))*($D$3:$O$5)),"")

Copy down

Use the following formulae in the cells stated:

Q3: =INDEX($B$3:$B$5,INT((ROWS($1:1)-1)/12)+1)

S3: =DATE(2021,MOD(ROWS($1:1)-1,12)+1,1)

W3: =INDEX($D$3:$O$5,MATCH(Q3,$B$3:$B$5,0),MATCH(TEXT(S3,"mmm"),$D$2:$O$2,0))

Copy these down as required.

I'm not sure where the data comes from for columns T, U and V.

Hope this helps.

Pete

Thanks to all