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 value that I would find in my fisrst column I cannot specify the column number because it is subject to adjustment when column values add or delete from the filter. I had looked at possibly moving the "Grand Total" column to be immediately adjacent to the values in my rows, however I get a message that I cannot modify the pivot table.
1 Reply
Sort By
Gerry, check GETPIVOTDATA function https://support.office.com/en-us/article/GETPIVOTDATA-function-8c083b99-a922-4ca0-af5e-3af55960761f