presenting repeated numbers

[excelNewbie22]

hi!
how can i know which set of numbers in col i is a part of the numbers in a2 and then present them in col m? with the adajcent cells like in n2 and o2 ?

test
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1									a1	a2	a3		wanted result	wanted result	wanted result
2	1-2-3-4-5-6	1	2	3	4	5	6		7-8-9	1-11-12-20-40-41	10-11-14-21-29-30		1-2-4	5-7-11-12-19-20	7-9-15-18-23-26
3									10-11-15	2-22-23-33-44-45	6-7-19-22-23-28
4									1-2-4	5-7-11-12-19-20	7-9-15-18-23-26
test

 

[excelNewbie22]

maybe lookup? with several combinations of b2:g2?

 

[excelNewbie22]

somebody please?

 

[excelNewbie22]

make a progress, but in a long way,
can someone have a way to shorten it?
if not, how can i filter the blanks in i7?
and what i'm missing i i9 in order for it to populate results like in i11?

test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1									a1	a2	a3		wanted result	wanted result	wanted result
2	1-2-3-4-5-6	1	2	3	4	5	6		7-8-9	1-11-12-20-40-41	10-11-14-21-29-30		1-2-4	5-7-11-12-19-20	7-9-15-18-23-26
3	2								10-11-12	2-22-23-33-44-45	6-7-19-22-23-28
4									1-2-4	5-7-11-12-19-20	7-9-15-18-23-26
5
6								step 1	1-2-3	1-2-4	1-2-5	1-2-6	1-3-4	1-3-5	1-3-6	1-4-5	1-4-6	1-5-6	2-3-4	2-3-5	2-3-6	2-4-5	2-4-6	2-5-6	3-4-5	3-4-6	3-5-6	4-5-6
7								step 2		1-2-4
8
9								step 3	FALSE
10									0
11									5-7-11-12-19-20	7-9-15-18-23-26
test

Cell Formulas
Range	Formula
J6	J6	=B2&"-"&C2&"-"&E2
K6	K6	=B2&"-"&C2&"-"&F2
L6	L6	=B2&"-"&C2&"-"&G2
M6	M6	=B2&"-"&D2&"-"&E2
N6	N6	=B2&"-"&D2&"-"&F2
O6	O6	=B2&"-"&D2&"-"&G2
P6	P6	=B2&"-"&E2&"-"&F2
Q6	Q6	=B2&"-"&E2&"-"&G2
R6	R6	=B2&"-"&F2&"-"&G2
S6	S6	=C2&"-"&D2&"-"&E2
T6	T6	=C2&"-"&D2&"-"&F2
U6	U6	=C2&"-"&D2&"-"&G2
V6	V6	=C2&"-"&E2&"-"&F2
W6	W6	=C2&"-"&E2&"-"&G2
X6	X6	=C2&"-"&F2&"-"&G2
Y6	Y6	=D2&"-"&E2&"-"&F2
Z6	Z6	=D2&"-"&E2&"-"&G2
AA6	AA6	=D2&"-"&F2&"-"&G2
AB6	AB6	=E2&"-"&F2&"-"&G2
I6	I6	=B2&"-"&C2&"-"&D2
I7:AB7	I7	=IF(ISERROR(MATCH(I6:AB6,$I$2:$I$4,0)),"",B2&"-"&C2&"-"&E2)
I9	I9	=IF(OR(I2=$J$7,J2:K2),IF(OR(I3=$J$7,J3:K3),IF(OR(I4=$J$7,J4:K4),0)))
I10,I11:J11	I10	=IF(I3=$J$7,J3:K3,0)
Dynamic array formulas.

 

[excelNewbie22]

had a mistake in i7 but still need help with above problems
except figure out this in i9

=IF(I2=$J$7,J2:K2,IF(I3=$J$7,J3:K3,IF(I4=$J$7,J4:K4,0)))

test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1									a1	a2	a3		wanted result	wanted result	wanted result
2	1-2-3-4-5-6	1	2	3	4	5	6		7-8-9	1-11-12-20-40-41	10-11-14-21-29-30		1-2-4	5-7-11-12-19-20	7-9-15-18-23-26
3	2								10-11-12	2-22-23-33-44-45	6-7-19-22-23-28
4									1-2-4	5-7-11-12-19-20	7-9-15-18-23-26
5
6								step 1	1-2-3	1-2-4	1-2-5	1-2-6	1-3-4	1-3-5	1-3-6	1-4-5	1-4-6	1-5-6	2-3-4	2-3-5	2-3-6	2-4-5	2-4-6	2-5-6	3-4-5	3-4-6	3-5-6	4-5-6
7								step 2		1-2-4
8
9								step 3	5-7-11-12-19-20	7-9-15-18-23-26
10
test

Cell Formulas
Range	Formula
J6	J6	=B2&"-"&C2&"-"&E2
K6	K6	=B2&"-"&C2&"-"&F2
L6	L6	=B2&"-"&C2&"-"&G2
M6	M6	=B2&"-"&D2&"-"&E2
N6	N6	=B2&"-"&D2&"-"&F2
O6	O6	=B2&"-"&D2&"-"&G2
P6	P6	=B2&"-"&E2&"-"&F2
Q6	Q6	=B2&"-"&E2&"-"&G2
R6	R6	=B2&"-"&F2&"-"&G2
S6	S6	=C2&"-"&D2&"-"&E2
T6	T6	=C2&"-"&D2&"-"&F2
U6	U6	=C2&"-"&D2&"-"&G2
V6	V6	=C2&"-"&E2&"-"&F2
W6	W6	=C2&"-"&E2&"-"&G2
X6	X6	=C2&"-"&F2&"-"&G2
Y6	Y6	=D2&"-"&E2&"-"&F2
Z6	Z6	=D2&"-"&E2&"-"&G2
AA6	AA6	=D2&"-"&F2&"-"&G2
AB6	AB6	=E2&"-"&F2&"-"&G2
I6	I6	=B2&"-"&C2&"-"&D2
I7:BK7	I7	=IF(ISERROR(MATCH(I6:BK6,$I$2:$I$4,0)),"",I6:BK6)
I9:J9	I9	=IF(I2=$J$7,J2:K2,IF(I3=$J$7,J3:K3,IF(I4=$J$7,J4:K4,0)))
Dynamic array formulas.