Pivot Table & Vlookup Combined?

[somebody113]

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/Jtracking2UPPER.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!

Cross posted:

http://www.excelforum.com/excel-pro...d-vlookup-combined.html?p=2664245#post2664245
http://www.ozgrid.com/forum/showthread.php?t=160814&p=588225#post588225
http://www.mrexcel.com/forum/showthread.php?p=2967147#post2967147

 

[Robert Mika]

Hi somebody,
You are always better of to post your data here.

Which part of your formula does not work?
I enter this:
=VLOOKUP(A5,$M$4:$O$89,2,0)
into column E and that gave me few matches.

You can download and install two of the following programs:

HTLMaker

or
Excel Jeanie


or when using Internet Explorer just put borders around your data in Excel and copy those cells into your post.

 

[somebody113]

Hey Robert, yeah some of the data populates correctly, but not all of it, it's so wierd.

 

[Robert Mika]

Could you post an example with not working formulas?