• 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

    Hui...

  • 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

M

marwanali89

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:

72068

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?
 
marwanali89
As You're a new member, You should reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
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?
 
You must log in or register to reply here.
Back
Top