Hi again,

The longer formula is:

=IF(ISERR(INDEX($C$4:$C$22,LARGE((MAX($E$4:$E$22)= $E$4:$E$22)*ROW($E$4:$E$22),ROW(A1))-3,1)),"",INDEX($C$4:$C$22,LARGE((MAX($E$4:$E$22)=$ E$4:$E$22)*ROW($E$4:$E$22),ROW(A1))-3,1))

Again it must be array entered.
--
Cheers,
Shane Devenshire


"Jeff Reese" wrote:

Hello.

I'm using Excel 2007.

I have this formula in a cell:
=GETPIVOTDATA("Overall Rating",$DU$7,"fweek","200829")

When I change the fweek value to a cell refrence as in the formula below, I
get a #REF error (where DY22 contains the value "200829"):
=GETPIVOTDATA("Overall Rating",$DU$7,"fweek",DY22)

What is puzzling is that I have many other formulas just like this that
work. The only difference is that those formulas reference pivot tables that
were originally built in 2003 (the file was converted from 2003 to 2007) and
my formula that errors out is referencing pivot tables built in 2007.

Any thoughts on what the problem could be?

Any assistance is appreciated. Thanks.

--
Jeff