Hi
In this case where the data is from a pivottable, it might be easier to use GETPIVOTDATA
This formula to be placed in B3
[EDIT] : This is how GETPIVOTDATA is used in excel 97 and 2000. This old syntax works in XP, but XP's syntax doesn't work in 97/2000, so I would choose the old syntax for compability.PHP Code:
=IF(ISERROR(GETPIVOTDATA(Data!$A$3;B$2 & " " & $A3));"";GETPIVOTDATA(Data!A3;B$2 & " " & $A3))
BR
Tommy Bak