G Guest Nov 28, 2006 #2 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
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 Nov 29, 2006 #3 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.
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.
