Using Index function with multiple criteria

[trone77]

I am currently using the following formula to extract from the columns below on the left containing various 3 digit numbers:

{=IFERROR(INDEX(B$1:B$21,SMALL(IF($B$1:$B$21=$H$3,ROW($B$1:$B$21)),ROW(1:1))),"")}
So in the first example I am looking for the value of 1 for the first digit and extract the full 3 digit string which returns the 124, 118, 103.

{=IFERROR(INDEX(C$1:C$21,SMALL(IF($C$1:$C$21=$I$10,ROW($C$1:$C$21)),ROW(1:1))),"")}
Same for the second digit being 5 which returns 657, 555, 259 for the second example.

But what I am looking to accomplish is to implement a second criteria using the above formulas. So in the example using the value of 3(1st) digit and 4(2^nd) digit to return the final number in the string which would be 347, 340, 341.

A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
3	1	2	4				1	_	_				3	4	_
4	3	4	7
5	6	5	7			1	1	2	4			1	3	4	7
6	2	7	3			2	1	1	8			2	3	4	0
7	1	1	8			3	1	0	3			3	3	4	1
8	0	0	2
9	7	0	3
10	5	5	5				_	5	_				_	2	4
11	2	5	9
12	4	3	0			1	6	5	7			1	1	2	4
13	7	7	2			2	5	5	5			2	4	2	4
14	4	2	4			3	2	5	9			3	7	2	4
15	2	2	2
16	1	0	3
17	7	1	3				_	_	2				7	_	3
18	3	4	0
19	7	2	4			1	0	0	2			1	7	0	3
20	7	8	3			2	7	7	2			2	7	1	3
21	3	4	1			3	2	2	2			3	7	8	3

<colgroup><col span="6"><col><col span="9"></colgroup><tbody>
</tbody>

 

[Nishant94]

I have changed the format. Can you work with this:

Book1
	A	B	C	D	E	F	G	H	I	J
1					Criteria_1	Criteria_2	Criteria_3
2	1	2	4		1	_	_	1	2	4
3	3	4	7					1	1	8
4	6	5	7					1	0	3
5	2	7	3		3	4	_	3	4	7
6	1	1	8					3	4	0
7	0	0	2					3	4	1
8	7	0	3		_	5	_	6	5	7
9	5	5	5					5	5	5
10	2	5	9					2	5	9
11	4	3	0		_	2	4	1	2	4
12	7	7	2					4	2	4
13	4	2	4					7	2	4
14	2	2	2		_	_	2	0	0	2
15	1	0	3					7	7	2
16	7	1	3					2	2	2
17	3	4	0		7	_	3	7	0	3
18	7	2	4					7	1	3
19	7	8	3					7	8	3
20	3	4	1
Sheet11

Cell Formulas
Range	Formula
H2	{=IFERROR(INDEX(A$2:A$20,SMALL(IF(ISNUMBER(SEARCH(SUBSTITUTE(INDEX($E$1:E2&$F$1:F2&$G$1:G2,MAX(IF(E$1:E2<>"",ROW(E$1:E2)-ROW($E$1)+1))),"_","?"),$A$2:$A$20&$B$2:$B$20&$C$2:$C$20)),(ROW($A$2:$A$20)-ROW($A$2)+1)),ROWS(INDEX(H$1:H2,MAX(IF(E$1:E2<>"",ROW(E$1:E2)-ROW($E$1)+1))):H2))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[trone77]

Ok how about this, what formula would I need to accomplish just this:

A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
3	1	2	4										3	4	_
4	3	4	7
5	6	5	7									1	3	4	7
6	2	7	3									2	3	4	0
7	1	1	8									3	3	4	1
8	0	0	2
9	7	0	3
10	5	5	5
11	2	5	9
12	4	3	0
13	7	7	2
14	4	2	4
15	2	2	2
16	1	0	3
17	7	1	3
18	3	4	0
19	7	2	4
20	7	8	3
21	3	4	1

<colgroup><col span="6"><col><col span="9"></colgroup><tbody>
</tbody>