Forum Discussion
JenneyVolp
Mar 09, 2020Copper Contributor
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 ...
- Mar 09, 2020
JenneyVolp Something like in the attached file perhaps.
JenneyVolp
Mar 09, 2020Copper Contributor
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
Riny_van_Eekelen
Mar 09, 2020Platinum Contributor
JenneyVolp Something like in the attached file perhaps.
- JenneyVolpMar 09, 2020Copper Contributor