Is it possible to conduct a vlookup from one pivot to another?
Posted on 2009-05-13
I have 2 pivot tables. If I expand a row it shows numbers. I'd like too lookup those numbers from another pivot. E.g.
What I'd like PivotTable1 to do is lookup 001 and 002 from PivotTable2 to show me who the members are. Is this possible?