Return values from one sheet to another. Sheets have different structures.

I am trying to return the values from Sheet 2 into Sheet 1. The structures as you will see are vastly different. Any help is appreciated.

Try

in B2

=INDEX(Sheet2!$B$1:$M$55,MATCH(Sheet1!$A2,Sheet2!$A$1:$A$55,0)+COLUMNS($A:A),1)

Copy across to G and down to row 8

Copy B2 to B11 and change 1 to 2

Repeat for all months changing 2 to 3 etc

Awesome, thanks!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.