Index/indirect, REF problem

[SannyW]

Hey.

Is stuck with the problem of having a solution, but not in the way I hoped.

The code works when being in the same workbook. But here comes the problem, I am trying to get values from a closed workbook. And on top of that I didnt think about that the links gets hardcode inside the indirect.

INDEX(INDIRECT("B"&MATCH("Eko";C:C;0)+3&":L"&MATCH("Eko";C:C;0)+33&"");MATCH("fr 8/3-2013";
INDIREKT("B"&MATCH("Eko";C:C;0)+3&":B"&MATCH("Eko";C:C;0)+33&"");0);MATCH("Sales";
INDIREKT("B"&MATCH("Eko";C:C;0)+2&":L"&MATCH("Eko";C:C;0)+2&"");0)

Workbook1
Has dates on every row down to say 31. Here I have my above code with the match to the row I am at and creates Ex. "fr 8/3-2013". This then matches with a row in Workbook2.

Workbook2 looks like this:

B	C	D	E	F	G
	Eko
Dates	Sales
Fr 1/3-2013	300
Sa 2/3-2013	100
Su 3/3-2013	20
Mo 4/3-2013	50
Sum

Then there is more tables with same range below this one.

So im trying to find first MATCH (Ex. Eko), then go down 3 rows and -1 column to start a range from 1-31 rows. In this range MATCH the specific date and get the a value from another column (Ex. Sales column).

Does anyone have any ideas where to go next with this?

[FDibbins]

Hi, welcome to the forum

Your problem is that INDIRECT does not work on closed workbooks. An option may be to install the Morefuc add-in, found here...
http://www.ashishmathur.com/tag/morefunc/

[SannyW]

Thank you Ford.
It would be the easier solution. Problem is that the file will be opened by multiple users and computers.

It does look like I need to re-think and find a new strategi..

[FDibbins]

This is an add-in that would be required on all computors that will use that file