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.

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")


Louja wrote:
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
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com