vlookup data in a dynamic pivot table?

M

MikeM

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.
 
G

Govind

Hi,

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

Regards

Govind.
 
M

MikeM

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.
 
G

Govind

Getpivotdata can pull any information depending on the criteria you
give. You can find examples of how to write Getpivotdata in Microsoft help.

If you provide more details on the layout of your pivot table, and the
field you want to return, i can type in an example of how the formula
would look like.

Regards

Govind.
 
M

MikeM

Hi & Happy New Year

My Pivot table has 2 fields in the Page area (channel & status), 1 field in
the Row area (category) and 3 fields being summed in the data area (forecast,
sales & difference).
The data I am trying to get is the summed forecast by category (by vlookup
the category name).

Thanks, Mike
 
Top