I am having trouble getting the desired results using Index Match
The formula is as follows.
=INDEX([RMSDaily.xls]Department!$C$4:$D$87,MATCH([RMSDaily.xls]Department!$C$2,[RMSDaily.xls]Department!$C$2:$D$2,0),MATCH("Grand Total",[RMSDaily.xls]Department!$A$2:$A$87,0),1)

If I select the "Match" and test the function I am getting the row number and coulmn number. However if I select with Index for the Data range, I am getting "#Ref" as the result.
The data is a Pivot Table and it has 217columns and 88 rows.Will that pose problem using Index and Match?
Please help me.
Thanks.
Krish