Forum Discussion

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

PivotTables help

just wondering if there is a way to add the "Comments field" from my selected data to the right side of my data columns so it lines up with the corresponding data in the row (red column in the image ...
excel
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

 

 

Resources