Sorry, you said B2 and I used B5.

If it works with "SUNDRY EXPORT USD" in the formula and "SUNDRY EXPORT USD"
is in cell B2, then it should work with B2 in the formula. Are you sure you
don't have trailing spaces in cell B2, same number of spaces before USD?
Obviously, the text must be exactly the same so that is where I would be
looking for an error.

I just noticed what appears to be an extra set of brackets.


=(GETPIVOTDATA("Sum of Qty",'Y:\Spares sales\[2008.xls]2008
Table'!$A$5,"Customer Name","SUNDRY EXPORT USD"))

Should be:

=GETPIVOTDATA("Sum of Qty",'Y:\Spares sales\[2008.xls]2008
Table'!$A$5,"Customer Name","SUNDRY EXPORT USD")

Or:

=GETPIVOTDATA("Sum of Qty",'Y:\Spares sales\[2008.xls]2008
Table'!$A$5,"Customer Name",$B2)

I hope this helps.

Tom