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?