Hi again,

So I need to look up a value from one spreadsheet,
Sheet 1.JPG

value in column A, and the week number in column f, then search data from another spreadsheet:

Last 12 Weeks.JPG

I need to pull through the data from the row & column as defined in the first spreadsheet.

However I also then need it to pull data from the following 12 columns for that row from the column definded in the first instance.

So for example I want to look up row 1234567, and week 201613 in the data file, and sum cells T to AE in that row.

I've tried allsorts and I'm sure it can be done, I just cant figure out a way.

Any help is much appreciated