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