Solved - Changing cell contents in named cell while using a pivot table

[Graham Cooper]

I use a pivot table to extract info from a financial data table. By way of example, the attached pivot table breaks down the data by product, and further by the dates associated with each of the products. I reference the data associated with each of the products within the pivot table for use elsewhere by naming them (in the attached example, “shoe” referencing C5). However if by way of example, I expand the pivot table to show the rows showing the transaction dates of the product “heel”, the value of the “shoe” category, which I want to capture moves to C8, but my named cell remains at C5, therefor returning incorrect data. What can I do to ensure that when referring to the named cell, I always get the correct data, even when expanding peoduct fields?

[ChemistB]

You could use this formula (forget the named range)

=GETPIVOTDATA("Price",B3,"Product","Shoe")

Would that work for you?

[Graham Cooper]

Perfect! Thanks. You learn something new everyday.