getpivotdata

[Pat Salmon]

I am using Excel 2000. I am using the getpivotdata to
retrieve data from the pivot table and having inconsistent
results. It appears to have the correct formula's, but
works for one column and not the next, or for two columns
and misses one.

the formula is:=IF(ISERROR(GETPIVOTDATA($C$12,$C$8 & " "
&TEXT(D7,"mmm-yy"))),0,GETPIVOTDATA($C$12,$C$8 & " " &TEXT
(D7,"mmm-yy")))

Any ideas??

Thanks

 

[Guest]

The cell reference will change from column to column, the
column to the right will reference E7. The formula's
appear to be identical, but only return correct data
sporadially. If the ISERROR function is removed I get a
#N/A result.

Thanks

 

[Debra Dalgleish]

What's in cells C8 and C12, and what's in row 7 (D7, E7, etc)?