Forum Discussion
Gerry Poppe
Aug 17, 2017Copper Contributor
How to retrieve values at intersections in Pivot Table
I have a pivot table which has expanding and contracting columns. I need to be able to retrieve data from the intersection of the "row" and the "Grand Total" column. If I use the Vlookup using the ...
SergeiBaklan
Aug 17, 2017Diamond Contributor
Gerry, check GETPIVOTDATA function https://support.office.com/en-us/article/GETPIVOTDATA-function-8c083b99-a922-4ca0-af5e-3af55960761f