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.