Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup within GetPivotData formula
Is it possible to use a Vlookup along with a GetPivotData formula?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup within GetPivotData formula
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
VLOOKUP Formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions |