Forum Discussion

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

Riny_van_Eekelen
Mar 09, 2020
JenneyVolp Something like in the attached file perhaps.

audit results with Pivot Tables_rev.xlsx410 KB

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

audit results with Pivot Tables.xlsx405 KB