Return a dynamic reference to a cell beside a pivot table

[sbolt6]

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

 

[bosco_yip]

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

 

[sbolt6]

Wow! That is excellent. Thank you very much Bosco!!!

Scott