Search for first time text occurs, then display TEXTJOIN

[Nanaia]

I'm trying to figure out how to write a formula that searches B9:AF9 for the first column that the code NS appears, then display a TEXTJOIN of the data in row 5 of that column, cell G1, and H1. I understand how to use LOOKUP, INDEX, and MATCH working with columns but not with rows. So if NS appears in D9, the results of the TEXTJOIN would be the data in D5,G1,H1. Can any one help?

 

[JamesCanale]

Mr Excel Playground 3.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	A	B	C	D	E	Silly	Goose	H	I	J	K	L	M	N	O
2	13	11	19	10	12	19	20	16	14	12	19	20	18	16	11
3	12	10	18	11	19	10	18	16	14	16	13	17	16	15	11
4	13	12	12	10	14	19	11	17	20	17	10	18	12	11	11
5	16	13	13	15	15	14	12	11	16	13	12	10	10	11	10
6	15	17	11	12	19	12	13	10	14	20	18	19	16	20	16
7	18	20	13	11	17	19	17	13	20	15	11	16	10	17	11
8	15	17	20	16	17	17	12	17	14	10	10	16	13	14	19
9	a	b	c	d	e	f	NS	h	i	j		k	l	NS	g
10
11
12			12SillyGoose
Sheet27

Cell Formulas
Range	Formula
D12	D12	=TEXTJOIN("",TRUE,INDEX(B5:AF5,1,XMATCH("NS",B9:AF9,0,1)),G1,H1)

 

[Nanaia]

Mr Excel Playground 3.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	A	B	C	D	E	Silly	Goose	H	I	J	K	L	M	N	O
2	13	11	19	10	12	19	20	16	14	12	19	20	18	16	11
3	12	10	18	11	19	10	18	16	14	16	13	17	16	15	11
4	13	12	12	10	14	19	11	17	20	17	10	18	12	11	11
5	16	13	13	15	15	14	12	11	16	13	12	10	10	11	10
6	15	17	11	12	19	12	13	10	14	20	18	19	16	20	16
7	18	20	13	11	17	19	17	13	20	15	11	16	10	17	11
8	15	17	20	16	17	17	12	17	14	10	10	16	13	14	19
9	a	b	c	d	e	f	NS	h	i	j		k	l	NS	g
10
11
12			12SillyGoose
Sheet27

Cell Formulas
Range	Formula
D12	D12	=TEXTJOIN("",TRUE,INDEX(B5:AF5,1,XMATCH("NS",B9:AF9,0,1)),G1,H1)

YOU are a ROCKSTAR! Thank you!