Vlookup within GetPivotData formula

D

Dave F

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
 
D

Debra Dalgleish

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