Vlookup and Pivot Tables

colinheslop1984

Board Regular
Joined
Oct 14, 2016
Messages
113
I have a pivot table of data which gets updated daily, some products that might appear one day as they are new, some products may disappear once sold out. Its a regular changing data set.

Within this data set are unit cost prices. I want to use a best seller list I get from a different report, lookup the items I have sold to get their cost price for me to then work out GM.

Vlookup doesn't work with a pivot table.

Are there any workarounds anyone can suggest?
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,550
You can add the data sets to PowerPivot, create a relationship and put in a new Pivot.

Another option is do the lookup next to the pivot and run a macro on pivot refresh to tidy it up (add or remove rows) as the size of the table changes.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,019
Messages
5,575,597
Members
412,678
Latest member
ruturajs7rs
Top