• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Advanced Lookup Function


New Member
Hi all,

I have an excel problem that I cannot seem to crack. I have a sales forecast workbook with tabs for each week and on the master sheet I want to create a data validation drop down where I can select a week, say "Week 1" and it would look up values from both Week 1 tab and Week 2 tab and populate the difference between the two in the master sheet. This is what the master sheet looks like:


The pink tabs are the ones for each week. What formula can I use in each cell in the above master sheet to lookup the difference between values in each sheet based on the week selection from a drop down?


Excel Ninja
As You're a new member, You should reread Forum Rules
especially How to get the Best Results at Chandoo.org
After that, You'll remember/notice - what should You add for Your thread?
Why do You need to use weekly sheets?