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" )
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"
)
pruduct activation failedLorenzo