Pivot Table & Vlookup Combined?

Hey Guys,

I'm pretty new with pivot tables. I'm trying to match up my cost data with revenue data by ad. I'm trying to use
Vlookup with the pivot table and its not working, I've been googling answers and it's driving me insane

I've attached the sheet

http://www.testarvixespeed.com/TRUE/...ing2UPPER.xlsm

So in the sheet "compiled" all I'm trying to do is combine my cost and revenue data so....

MATCH up the Ads(summed up data) in column A and Column M

and then Get the corresponding data in columns B,C,D,N,O to follow along.

So basically just match up all the data.

Thanks for the help guys!

http://www.excelforum.com/excel-prog...45#post2664245
http://www.ozgrid.com/forum/showthre...225#post588225
http://www.mrexcel.com/forum/showthr...47#post2967147

After you do your 2 pivots. Go to an empty column (in this example - column E) and input a regular vlookup to reference the 2nd pivot. For e.g. =VLOOKUP(A5,$M:$O,2,0) and put this in column F - =VLOOKUP(A5,$M:$O,3,0). Drag down to all the rows of pivot 1. You will get the values you require.

To get rid of the #N/A, you can alter the formula a bit as - =IFERROR(VLOOKUP(A5,$M:$O,2,0),"")