GETPIVOTDATA on Excel 2000

[Louja]

Hi,

I have seen that you can use GETPIVOTDATA with more than one field on
Excel 2003 and 2007. But is there any way of doing this with Excel
2000.

I am currently using SUMPRODUCT to do a vlookup which has more than
one variable. Is there another solution as this takes forever when
the spreadsheet needs to recalculate.

 

[Debra Dalgleish]

Yes, you can use multiple fields in an Excel 2000 GETPIVOTDATA formula.
For example, to see records for the Central region, for Truck sales, by
salesperson Wilson:

=GETPIVOTDATA($A$4,"Central Trucks Wilson")