Is it possible to use a Vlookup along with a GetPivotData formula?
Dave F - 28 Nov 2006 16:14 GMT
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

Signature
Brevity is the soul of wit.
> Is it possible to use a Vlookup along with a GetPivotData formula?
Debra Dalgleish - 29 Nov 2006 04:33 GMT
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.
> Is it possible to use a Vlookup along with a GetPivotData formula?

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