Doesn't GetPivotData only return grand total information? I was hoping to
reference the pivottable in the vlookup function like you would a list or
external data source.


"Govind" wrote:

Hi,

Try using the Getpivotdata formula to extract information out of a
dynamic pivot.

Regards

Govind.

MikeM wrote:

Is it possible to use vlookup to get data from a pivot table by entering the
pivot table name as the array to look up? I have tried but cannot get it to
work.