Lookup value from reversed columns and rows

[szakharov7723]

Source table
[TABLE="width: 508"]
<colgroup><col><col span="5"><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD]tine 2[/TD]
[TD]tine 2[/TD]
[TD]tine 2[/TD]
[TD]Hitte 3[/TD]
[TD]Hitte 3[/TD]
[TD]Hitte 3[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]PM assigned[/TD]
[TD]WO assigned[/TD]
[TD]Task assigned[/TD]
[TD]PM assigned[/TD]
[TD]WO assigned[/TD]
[TD]Task assigned[/TD]
[/TR]
[TR]
[TD]18-May[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]19-May[/TD]
[TD="align: right"]6.5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]96[/TD]
[/TR]
[TR]
[TD]20-May[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]21-May[/TD]
[TD="align: right"]7.5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]2.56[/TD]
[/TR]
[TR]
[TD]22-May[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]23-May[/TD]
[TD="align: right"]4.5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]5.76[/TD]
[/TR]
[TR]
[TD]24-May[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]3.2[/TD]
[TD="align: right"]6.4[/TD]
[/TR]
</tbody>[/TABLE]

Table to implement lookup

[TABLE="width: 682"]
<colgroup><col><col><col span="2"><col><col span="3"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]18-May[/TD]
[TD]19-May[/TD]
[TD]20-May[/TD]
[TD]21-May[/TD]
[TD]22-May[/TD]
[TD]23-May[/TD]
[TD]24-May[/TD]
[/TR]
[TR]
[TD]tine 2[/TD]
[TD]PM assigned[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]tine 2[/TD]
[TD]WO assigned[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]tine 2[/TD]
[TD]Task assigned[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hitte 3[/TD]
[TD]PM assigned[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hitte 3[/TD]
[TD]WO assigned[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hitte 3[/TD]
[TD]Task assigned[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

This is only an example of a large database I have with bunch of other formulas. So I cannot change the structure of tables, especially 2nd one.
I need to find a way to create a look up for 2nd table. Both tables are not static, as new locations can added meaning 1st table can extend in columns, while 2nd table will be extended in rows. When this happens I would like a casual user to have no problem extending the formula for new locations.
So far I tried Sumproduct and IndexMatch : both didn't work out, however I could make a mistake somewhere. I tried to Concatenate location and assigned, but still didn't get any good result.
VBA might be a solution, but I would still prefer a formula approach.

 

[Comfy]

Here's one way:

Excel 2010
	A	B	C	D	E	F	G	H	I	J
1
2			tine 2	tine 2	tine 2	Hitte 3	Hitte 3	Hitte 3
3			PM assigned	WO assigned	Task assigned	PM assigned	WO assigned	Task assigned
4		18-May	6	1	0	48	0	0
5		19-May	6.5	1	0	48	0	96
6		20-May	7	1	12	48	48	64
7		21-May	7.5	7	12	24	80	2.56
8		22-May	4	1	0	64	16	0
9		23-May	4.5	1	18	72	16	5.76
10		24-May	5	10	20	80	3.2	6.4
11
12
13
14
15
16
17
18
19
20				18-May	19-May	20-May	21-May	22-May	23-May	24-May
21		tine 2	PM assigned	6	6.5	7	7.5	4	4.5	5
22		tine 2	WO assigned	1	1	1	7	1	1	10
23		tine 2	Task assigned	0	0	12	12	0	18	20
24		Hitte 3	PM assigned	48	48	48	24	64	72	80
25		Hitte 3	WO assigned	0	0	48	80	16	16	3.2
26		Hitte 3	Task assigned	0	96	64	2.56	0	5.76	6.4
Sheet1

Cell Formulas
Range	Formula
D21	{=INDEX($C$4:$H$10,MATCH(D$20,$B$4:$B$10,0), MATCH(1,($C$2:$H$2=$B21)*($C$3:$H$3=$C21),0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[szakharov7723]

Thank you a lot.
That's what I have been looking for.

 

[szakharov7723]

Is it possible to create formula that would sum values by several dates for each location and assigned in the same case ?