• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Return a dynamic reference to a cell beside a pivot table

sbolt6

New Member
Hello again Everyone,

I am trying to find a way to return values in cells beside a pivot table. The data set that the original pivot table draws from does not contain certain data so it is accumulated in a second worksheet. What I want to know is if I can return specific values to match up with the pivot table data. If the original pivot table changes, I would like the data returned to still match up.

I have attached an example for reference. (note the pivot table data is only a small excerpt) I hope this example is clear enough to understand.

Thank you in advance.

Scott
 

Attachments

  • Dynamic reference with Pivot table.xlsx
    17.3 KB · Views: 3
Maybe…..............

In M5, copied across and down :

=IFERROR(OFFSET('HRs-L-KMs'!$A$1,MATCH(LOOKUP("zzz",$B$1:$B5),'HRs-L-KMs'!$A$2:$A$100,0),MATCH("FY"&RIGHT($C5,2)&" "&$M$4,'HRs-L-KMs'!$B$1:$CZ$1,0)+COLUMNS($A:A)-1),"")

Regards
Bosco
 

Attachments

  • Dynamic reference with Pivot table(1).xlsx
    20.3 KB · Views: 5
Back
Top