1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. 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


  3. 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

Discussion in 'Ask an Excel Question' started by sbolt6, Feb 8, 2019.

  1. sbolt6

    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.


    Attached Files:

  2. bosco_yip

    bosco_yip Excel Ninja


    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),"")


    Attached Files:

    sbolt6 and Thomas Kuriakose like this.
  3. sbolt6

    sbolt6 New Member

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


Share This Page