Hello,
I am having trouble using the formula stated above. I want to be able to do about the same as the thread's initiator, thus I have just copied the formula, and changed it to contain what I need.

=INDEX(INDIRECT("'["&B2&".xls]'!$D2:$D1000");MATCH(C5;INDIRECT("'["&B2&".xls]'!$A$1:$A$1000"));MATCH(I2;INDIRECT("'["&B2&".xls]'!$C$4:$IV$4")))

When I use this formula I get the error "#REF!". I do not understand what this error refers to in this instance. Have I misused the formula?
Best regards Pelle Jorgensen