Vlookup within GetPivotData formula
 

Is it possible to use a Vlookup along with a GetPivotData formula?

Vlookup within GetPivotData formula
 

Probably not, because VLOOKUP (and other lookup formulas) require that data
be formatted in a table, not pivot table, format.

Perhaps one thing you could do would be to create a table using the
GETPIVOTDATA function, and then run the VLOOKUP off that table.

Others may have a better solution.

Dave
--
Brevity is the soul of wit.


"Spidey" wrote:

Is it possible to use a Vlookup along with a GetPivotData formula?

Vlookup within GetPivotData formula
 

You could use the two formulas together, for example using GetPivotData
to pull a value from the pivot table, and looking up that value in a list.

If you give an example of what you're trying to do, someone may be able
to offer specific help.

Spidey wrote:
Is it possible to use a Vlookup along with a GetPivotData formula?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html