ExcelBanter - GETPIVOTDATA on Excel 2000

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - GETPIVOTDATA on Excel 2000 (https://www.excelbanter.com/excel-worksheet-functions/229793-getpivotdata-excel-2000-a.html)

GETPIVOTDATA on Excel 2000

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.

GETPIVOTDATA on Excel 2000

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