Using Vlookup when you have two values to look up

[OmerTariq]

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.

[mrice]

Try pasting the following into cell B2 on the formula sheet and copying down and across.

=SUMIFS('Raw Data'!$C:$C,'Raw Data'!$A:$A,$A2,'Raw Data'!$B:$B,B$1)

[OmerTariq]

Thanks a lot mrice! I worked

This was my first post in the forum and what a nice start.