Forum Discussion
Solved
Help with Pivot Tables
Hello, I have an issue. I'm using Excel in the web version, and I was asked to link two sheets. The first sheet retrieves its data from the second sheet, which contains the data in a pivot table. The...
Hello Juan_Moreno
Corresponding sample shared https://1drv.ms/x/s!AsuqEFbTJNgcgaY9SWRu1asDLBzxCA?e=yBIJSE:
As you can see above in the source of my PivotTable the values are in column [Value]
So, with the PivotTable in B4 in sheet 'PivotTable' the formula in C4 is:
=IFERROR( GETPIVOTDATA("Value", PivotTable!$B$4, "CODIGO", [@CODIGO]), "Not found" )or if you prefer:
=IFERROR( GETPIVOTDATA("Value", PivotTable!$B$4, "CODIGO", B4), "Not found" )
Thank you! Lorenzo
You're welcome Juan_Moreno.
Next time(s) don't forget to Mark as response (link at the bottom of each reply your get here) - This helps people who Search. Thanks