Offset based on Match x 2 - Help

I have attached a very simple spreadsheet to demonstrate what I'm trying to achieve. I'll explain it in screenshots so it's clear:

1.jpg

2.jpg

3.jpg

The problem I have is my formula only pulls up the match for the month and not the week i.e. no matter if I choose week 35 or 36, it will always display it for week 36 as the formula currently only says match the month. I don't know how to ask it to match both the month and week.

Please Login or Register  to view this content.

4.jpg

So what I would like it to do is the following:

5.jpg

My current formula is not doing this, it is only matching Sheet 1 B3 with Sheet 2 Row C5 i.e the month. Does any one know how to make it match both criteria i.e. Match Sheet 1 B2 and B3 to Sheet 2 Row C4 and C5?

I have attached the spreadsheet so you can see what I'm trying to do, thanks guys!

File attached.

Help.xlsx

Thanks Ace! I will take in to consideration your suggestion about the layout. But thank you for the solution, appreciate it!

Hey guys, any chance you know how I can get it to copy the second column too? I've explained it in the screenshot below. I have tried to manipulate the formula given by Ace but no idea how to do it...?

For Ace.jpg

Current formula as given by Ace: {=INDEX(Sheet2!$D5:$M5,MATCH($B$2&$B$3,Sheet2!$C$4:$L$4&Sheet2!$C$5:$L$5,0))}

Thanks Ace! I should have figured that out but my head started hurting Thanks again, I appreciate it!