Getpivotdata

[Pranesh]

Hello All,

GetPivotdata formula will give column values from a Pivot. Is there any formula similar to it which will give row label data from a Pivot?

 

[RoryA]

There is no pivot table specific equivalent for non-value fields. You'd have to use something like VLOOKUP or INDEX/MATCH.

 

[Pranesh]

There is no pivot table specific equivalent for non-value fields. You'd have to use something like VLOOKUP or INDEX/MATCH.

Thanks Rory.

Can you please explain how to use INDEX/MATCH in Pivot?

 

[RoryA]

The same way you would use it anywhere. You use the MATCH part to find whatever value you are looking for in a row/column, then the INDEX part returns the value from another column/row. The fact that the source is a pivot table doesn't affect how the INDEX/MATCH works (other than the fact that rearranging the pivot table will likely break the formula).

 

[Pranesh]

The same way you would use it anywhere. You use the MATCH part to find whatever value you are looking for in a row/column, then the INDEX part returns the value from another column/row. The fact that the source is a pivot table doesn't affect how the INDEX/MATCH works (other than the fact that rearranging the pivot table will likely break the formula).

Thanks RoryA