I might be limiting myself to Vlookup here but lets take that as a starting point. You can suggest other ways too. I am working on a report where I have "Team" as well as information about whether the team is active or not. Eventually, I need to allot the distribution of costs to Active and nonactive areas.
I am attaching a dummy sheet which has the pivot table that I have applied. I am looking at the formula tab now, it would have been very easy for me if I just had to use vlookup for one thing like team. But since I have to look up team and then whether they were active or not, I am confused about which formula to use.
So in a perfect world the formula tab should show costs in the Active and Nonactive columns.
I hope I explained myself well. Please let me know if you have any questions.
Bookmarks