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?

sheet	column	row	output
1	1	3	??
2	2	4	??
3	1	2	??

<tbody>
</tbody>

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)