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?