Thanks for your reply! This is the formula as I use it.

=INDEX('[test bestand 1.xls]Blad1'!$A$1:$I$16,MATCH(A2;'[test file
1.xls]Blad1'!$B$1:$B$16;0),MATCH(B1;'[test file 1.xls]Blad1'!$A$1:$I$1;0))

What did you mean by "and do you have a semi-colon after the look-up value?"

best wishes,
Marieke

"Ragdyer" wrote:

Index/match formulas *will* work on closed WBs.

How about copying and posting your *exact* formula?

The pseudo formulas you posted are not exactly correct.
For instance, where's the Sheet name?, and do you have a semi-colon after
the look-up value?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mariekek5" wrote in message
...
I was very happy to find out about the possibilities of the INDEX/MATCH
combination...and making links to several source documents.

However, as the function MATCH alone is able to update automatically when
the source file is closed, the function INDEX/MATCH combination does not
(well I hope its possible, but I cant do it).

I am working on a destination file containing many links to several source
files using the formula:

=INDEX(array;row_num;column_num)

For array I use an array in the source file, for example [source file
x]$A$1:$D$11;
For row_num I use for example =MATCH(D3;[source file x]$B$1:$B$11,0)
For column_num I use for example =MATCH (A1;[source file x]$A$1:$D$1,0)

It works perfectly, and also it updates nicely when the source file is
open.
But for some reason it does not update when the source file is closed,
while
other functions do.

The source file and destination file are in the same folder on my
computer.
I am using Excel 2003.

Can somebody please help me?