Problem with index match to external workbook

[jamesaplant77]

I have a number of index match formulas that I use in order to produce MI, but I am struggling to pull through data from an external workbook which is stored on a network drive, this is the formula I am using:

=IFERROR(INDEX('[Consumer Timesheets 2016.xlsm]April 2016'!$AK$5:$AK$200,MATCH($C2&P$1,'[Consumer Timesheets 2016.xlsm]April 2016'!$C$5:$C$200&'[Consumer Timesheets 2016.xlsm]April 2016'!$B$5:$B$200)),"")

I have entered the full file paths and excel shortens the file path to the one shown above. I just want to bring the respective value in column AK in the consumer timesheet workbook, that matches cells C2 & P1 in the respective columns, C & B

Any help would be greatly appreciated.

 

[svendiamond]

Sorry what exactly is the issue? Does your formula not work? What error does it return?

 

[jamesaplant77]

svendiamond, it returns the value 0.00, when the value it should return is 8.00 (for example 8 hours have been assigned the project named in cell reference P1.

 

[svendiamond]

Is the other workbook open?