Forum Discussion

6 Replies

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Mar 09, 2020

    Hi JenneyVolp 

     

    You can add the comments in the master data & you use XLOOKUP or VLOOKUP to pull the comments from the mastersheet to pivottable

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official Answer.

    • JenneyVolp's avatar
      JenneyVolp
      Copper Contributor
      Mar 09, 2020

      ExcelExciting 

       

      thanks!

       

      would you have a formula I could use?

      I am having trouble with VLOOKUP.

       

      i am using the first two sheets on the spreadsheet attached.

      i need the "Comments" from the "DATA BANK" to be added into the "Comments" column in the Pivot table in "SHEET1" - i have highlighted these fields green for reference.

       

      Thanks

       

       

      • ExcelExciting's avatar
        ExcelExciting
        MVP
        Mar 09, 2020

        Hi JenneyVolp 

         

        Please see the attached excel sheet, I have used the dynamic arrays which is easier to solve your query 

        Attached is the solution file.

         

        Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

        If you find the above solution resolved your query don't forget mark as Official Answer.

Resources