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.