Pivot Table & Vlookup Combined?

S

somebody113

New Member
Joined
Apr 28, 2011
Messages
14
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
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Pivot table errors
Replies
4
Views
287
Alex Blakenburg
A
J
  • Question
Marking Top 10 in Criteria List
Replies
1
Views
105
Jezzzza
J
T
  • Question
Change pivot table source via VBA?
Replies
0
Views
246
TheWennerWoman
T
J
  • Question
If column B is empty and column C contains a value, show column A (also using Indirect to draw data from another workbook)
Replies
1
Views
88
Fluff
Fluff
A
  • Question
Conditional Formatting Pivot Table Data
Replies
4
Views
123
SanjayGMusafir
SanjayGMusafir

Forum statistics

Threads
1,215,923
Messages
6,127,717
Members
449,399
Latest member
VEVE4014

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top