View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default 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