Looking up Data

I am trying to lookup data based on multiple criteria. I have a vlookup with the if(and) function. I have attached an example.


Cell B2 Will change depending on the tab name for each Month.

I need starting with cell B7 to find the data that matches the for the team member, the stat month in cell b2 and the week in the cell b6-f6. I have the columns named the same as the data headers on the weekly team stats page. However that will not always be the exact same on the final project. So I will need to look based on a column number that I can change. If that makes any sense lol sorry if that is confusing.


I need to do this using ONLY formulas. I can't have any macros in this as it will need to be emailed & can't send workbooks with vba in them.

Thank you :-)