OtterlyAdorable
New Member
- Joined
- Apr 10, 2013
- Messages
- 5
I have a document that keeps track of a salespersons' sales. It has 2 tabs.
Tab A is used to display the data the salesman needs to know about his earnings for a given month in a clean, printable form. There's a drop down tab to select which month the sales manager wants to print information for. All of the information on this page references that cell, and then looks up the info in that month's column on tab B.
Tab B holds all of the applicable data, does the calculations, and is generally there because that's how my boss wanted it.
I have a section on tab B that the sales manager fills in with a salesperson's territories.
He wants to display each item in this list that actually made money for the month on Tab A.
For example, let's say there are 3 territories. North, South, and East. Jimmy the sales guy made $20 in North, $50 in South, and zero in East. North, South, and East are all listed on tab B, since Jimmy might have made money in East in different months, as well.
So now I need to figure out, what kind of formula do I need to get this result:
Check month selected in Tab A. Look up which territories under that month's column in Tab B are greater than 0. Display those values in the cells on Tab A.
Thanks so much in advance for your help!
Tab A is used to display the data the salesman needs to know about his earnings for a given month in a clean, printable form. There's a drop down tab to select which month the sales manager wants to print information for. All of the information on this page references that cell, and then looks up the info in that month's column on tab B.
Tab B holds all of the applicable data, does the calculations, and is generally there because that's how my boss wanted it.
I have a section on tab B that the sales manager fills in with a salesperson's territories.
He wants to display each item in this list that actually made money for the month on Tab A.
For example, let's say there are 3 territories. North, South, and East. Jimmy the sales guy made $20 in North, $50 in South, and zero in East. North, South, and East are all listed on tab B, since Jimmy might have made money in East in different months, as well.
So now I need to figure out, what kind of formula do I need to get this result:
Check month selected in Tab A. Look up which territories under that month's column in Tab B are greater than 0. Display those values in the cells on Tab A.
Thanks so much in advance for your help!
