index-match with dynamic sheet entry

[nielsb]

Hello,
does anybody know how to draw up an index-match formula with the possibility to search in another sheet, whereby using a dynamic entry for sheet?

[TABLE="width: 500"]
<tbody>[TR]
[TD]sheet[/TD]
[TD]column[/TD]
[TD]row[/TD]
[TD]output[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]??[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]??[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]??[/TD]
[/TR]
</tbody>[/TABLE]

Kind regards,
Niels

 

[sheetspread]

Use indirect

 

[nielsb]

I tried with INDIRECT but couldn't get it to work. In case you can I would be freatfull receiving a full formula..

Kind regards,
Niels

Use indirect

 

[sheetspread]

One way:

Excel 2010
	A	B	C
1	Name	Series1	Series2
2	Q	3	9
3	W	2	9
4	E	4	1
5	R	8	3
6	T	7	2
North

Excel 2010
	A	B	C
1	Name	Series1	Series2
2	A	55	76
3	S	66	65
4	D	22	56
5	F	32	88
6	G	43	92
South

Excel 2010
	A	B	C	D
1	Sheet	Column	Row	Output
2	South	2	3	22
3	North	1	4	R
Master

Cell Formulas
Range	Formula
D2	=INDEX(INDIRECT(A2&"!$A$2:$C$6"),C2,B2)