Summarize results from files into main file

You might be able to get the effect you yant using

=INDIRECT(ADDRESS(...))

Mark.

Hello there, sorry for not having posted a reply earlier. I have not tried the other =INDIRECT(ADDRESS(...)) but here is a testfile for someone ( special? just like me... )

Anyway:

In the example file below, the field ('Mainfile Y'!A3) should be checked against ='Example testfile X'!D6. If they are the same, I would like the values from ='Example testfile X'!B17 to be written into ='Mainfile Y'!B3.

It would also be nice if the values of =SUM('Example testfile X'!B19:B20)
were written into ='Mainfile Y'!C3.

And then.. of course, this should be a general formula and Mainfile and Example testfile are actually two different files ( not two tabpages ) that not necessarily are in the same folder ( but this I can change ).


Thanks in advance.

/Katti

Attachment- testfile