Multiple match's in the same cell.

[lu1zuk]

Sobe_e_Desce_2.0.xlsx
	A	B		D	E	F	G	H		J	K	L	M	N	O	P	Q	R	S	T
1	🐉 E X A 🐉 : tempo staff
2	Usuário	Tempo		Cargos	Separador	Horas	Separador	Qual a Equipe?		Ids									Equipe	ID
3	MGL229456993373519872	161 Horas 16 Minutos 49 Segundos		869353363609899042, 869353363622494315, 869353363635073066, 869353363635073071, 869353363647651886, 869353363647651889, 869353363656020030, 869353363656020033, 869353363656020035, 869353363668598799, 869353363668598801, 869353363677020210, 869353363677020212, 869353363677020215, 869353363677020219, 869353363714744337, 869353363794444395, 869353363807010852, 869353363815411754, 869353363815411755, 869353363832180797, 869353363844780126, 869353363861536791, 869353764727947324, 879479435332579329, 892270088286273586, 896811812132110336, 917381741084295198, 923768995981697114, 934915112270188555, 941733727610998804, 963086806784565328, 970862133929730138, 987429669550850118, 989523321014079488, 992073031348400138, 869353363609899038	|||	161	|||	Equipe Mov.Call		<@229456993373519872>								869353363815411757	Equipe Eventos	869353363815411757
4	oyuric755287807337169017	141 Horas 33 Minutos 9 Segundos		869353363609899042, 869353363635073066, 869353363635073072, 869353363668598798, 869353363668598799, 869353363668598801, 869353363677020210, 869353363677020212, 869353363677020215, 869353363807010852, 869353363807010855, 869353363815411753, 869353363823816720, 869353363861536791, 869353764727947324, 879479406039531562, 892270088286273586, 896811812132110336, 934915112270188555, 970862133929730138, 978155147928674324, 869353363609899038	|||	141	|||	Equipe Registro		<@755287807337169017>								869353363815411758	Auxiliar Eventos	869353363815411758
5	lais bianchessi960299650810794004	133 Horas 28 Minutos 38 Segundos		869353363609899042, 869353363635073066, 869353363635073072, 869353363647651883, 869353363647651889, 869353363656020029, 869353363656020030, 869353363656020032, 869353363668598798, 869353363668598799, 869353363668598801, 869353363668598804, 869353363677020212, 869353363677020215, 869353363807010852, 869353363815411754, 869353764727947324, 892270088286273586, 901201959556616212, 941733727610998804, 988969269536649246, 869353363609899038	|||	133	|||	Equipe Mov.Call		<@960299650810794004>								869353363815411754	Equipe Mov.Call	869353363815411754
6	! Ryo𝐾en961772149956309079	127 Horas 41 Minutos 13 Segundos		869353363609899040, 869353363609899042, 869353363609899044, 869353363635073066, 869353363635073068, 869353363635073069, 869353363647651889, 869353363656020029, 869353363656020031, 869353363656020034, 869353363668598798, 869353363668598799, 869353363668598802, 869353363677020210, 869353363677020212, 869353363677020214, 869353363677020215, 869353363731533894, 869353363807010852, 869353363815411754, 869353363815411757, 869353363874131972, 869353363886710784, 869353764727947324, 879479435332579329, 892270088286273586, 933510183257272321, 934915112270188555, 940077814516953088, 963086806784565328, 973715342046146590, 973715650528833598, 988969269536649246, 869353363609899038	|||	127	|||	Equipe Eventos		<@961772149956309079>								869353363815411756	Equipe Recrutamento	869353363815411756
7	Alves .мv858781483149819945	124 Horas 40 Minutos 17 Segundos		869353363609899040, 869353363635073068, 869353363647651880, 869353363656020033, 869353363668598799, 869353363677020210, 869353363677020212, 869353363677020214, 869353363677020215, 869353363794444395, 869353363807010852, 869353363815411758, 869353363832180800, 869353363886710784, 879479435332579329, 892270088286273586, 901201918481821697, 923768995981697114, 934915112270188555, 941733727610998804, 950958148557090836, 955288897632485427, 963086806784565328, 970862133929730138, 978155147928674324, 978779998502670416, 981030539815452672, 983118451012927518, 869353363609899038	|||	124	|||	Auxiliar Eventos		<@858781483149819945>								869353363815411755	Equipe Divulgação	869353363815411755
8	Gaguinho.lz931988559970332704	122 Horas 10 Minutos 24 Segundos		869353363609899040, 869353363609899042, 869353363635073066, 869353363635073071, 869353363668598798, 869353363668598799, 869353363668598801, 869353363668598804, 869353363677020212, 869353363677020215, 869353363807010852, 869353363807010855, 869353363815411754, 869353764727947324, 879479406039531562, 892270088286273586, 896811812132110336, 901201955903406171, 934915112270188555, 973019878900531271, 992073031348400138, 869353363609899038	|||	122	|||	Equipe Mov.Call		<@931988559970332704>								869353363815411752	Equipe CDC	869353363815411752
9	calango966333127716909118	122 Horas 6 Minutos 11 Segundos		869353363609899042, 869353363635073066, 869353363656020031, 869353363668598798, 869353363668598799, 869353363677020210, 869353363677020212, 869353363677020215, 869353363807010852, 869353363815411753, 869353363815411756, 869353363874131971, 869353764727947324, 892270088286273586, 934915112270188555, 963086806784565328, 973715650528833598, 978155147928674324, 991499849826578502, 869353363609899038	|||	122	|||	Equipe Recrutamento		<@966333127716909118>								869353363815411753	Equipe Registro	869353363815411753
10	! HUNTER370612816291561474	121 Horas 7 Minutos 14 Segundos		869353363647651886, 869353363656020032, 869353363656020033, 869353363668598797, 869353363668598798, 869353363668598802, 869353363668598804, 869353363677020212, 869353363677020214, 869353363677020215, 869353363714744338, 869353363807010852, 869353363815411754, 869353363823816722, 869353363844780126, 879479412733665312, 892270088286273586, 923768995981697114, 933510165607632906, 963086806784565328, 970862133929730138, 988969269536649246, 989523321014079488, 992073031348400138, 869353363609899038	|||	121	|||	Equipe Mov.Call		<@370612816291561474>								973715650528833598	Equipe Suporte	973715650528833598
11	! 𝘽𝙚𝙯𝙚𝙧𝙧𝙤👑906573722838761562	120 Horas 4 Minutos 11 Segundos		869353363609899042, 869353363635073066, 869353363656020031, 869353363656020035, 869353363656020037, 869353363668598797, 869353363668598798, 869353363668598799, 869353363668598802, 869353363677020210, 869353363677020212, 869353363677020214, 869353363677020215, 869353363794444395, 869353363807010852, 869353363815411754, 869353363815411759, 869353363823816720, 869353764727947324, 879479406039531562, 892270088286273586, 933510165607632906, 934915112270188555, 940077814516953088, 941733727610998804, 955288897632485427, 963086806784565328, 973715650528833598, 989523321014079488, 869353363609899038	|||	120	|||	Equipe Mov.Call		<@906573722838761562>								869353363807010855	Equipe Design	869353363807010855
12	! Sr.Natsuzinho667095822101512194	118 Horas 41 Minutos 54 Segundos		869353363609899042, 869353363635073066, 869353363668598801, 869353363668598804, 869353363677020212, 869353363677020214, 869353363677020215, 869353363807010852, 869353363807010855, 869353363815411754, 869353363844780126, 869353764727947324, 886458500862054470, 892138408418377730, 892270088286273586, 896811812132110336, 901201926312566845, 934915112270188555, 941733727610998804, 945458390333784146, 945790336070983750, 955288897632485427, 962805646099640340, 963086806784565328, 970207907369078784, 970862133929730138, 977985735317655552, 978155147928674324, 989523321014079488, 992073031348400138, 869353363609899038	|||	118	|||	Equipe Mov.Call		<@667095822101512194>								869353363807010854	Equipe Hot	869353363807010854
13	Guh ツ692180947990216725	112 Horas 7 Minutos 58 Segundos		869353363609899042, 869353363635073066, 869353363635073070, 869353363647651889, 869353363668598799, 869353363668598801, 869353363677020210, 869353363677020212, 869353363677020215, 869353363807010852, 869353363815411754, 869353764727947324, 892270088286273586, 896811812132110336, 901201926312566845, 934915112270188555, 935385249389608991, 978779998502670416, 989523321014079488, 992073031348400138, 869353363609899038	|||	112	|||	Equipe Mov.Call		<@692180947990216725>								896811812132110336	Equipe EXAFLIX	896811812132110336
14	! Tsuna 希787068655070347287	94 Horas 21 Minutos 39 Segundos		869353363609899040, 869353363609899042, 869353363622494314, 869353363622494315, 869353363635073066, 869353363647651883, 869353363647651886, 869353363647651889, 869353363656020029, 869353363668598798, 869353363668598799, 869353363668598802, 869353363677020210, 869353363677020212, 869353363677020217, 869353363731533902, 869353363794444395, 869353363807010852, 869353363832180800, 869353363886710784, 869353363886710791, 869353363895107672, 879479435332579329, 892270088286273586, 906937079194325092, 941733727610998804, 991499849826578502, 992073031348400138, 869353363609899038	|||	94	|||			<@787068655070347287>								962805646099640340	Equipe Jornalismo	962805646099640340
15	! bru 🍥795107916989857812	81 Horas 11 Minutos 54 Segundos		869353363668598801, 869353363677020210, 869353363677020212, 869353363677020217, 869353363807010852, 869353363815411753, 869353363832180797, 869353764727947324, 892270088286273586, 978155147928674324, 869353363609899038	|||	81	|||	Equipe Registro		<@795107916989857812>								993257880927076392	Equipe Games	993257880927076392
Planilha1

Cell Formulas
Range	Formula
H3:H15	H3	=IFERROR(@INDEX(S$3:S$15,AGGREGATE(15,6,(ROW(S$3:S$15)-ROW(T$3)+1)/ISNUMBER(SEARCH(T$3:T$15,D3)),1)),"")
J3:J15	J3	=CONCAT("<@",I3,">")
F3:F15	F3	=--SUBSTITUTE(LEFT(B3,3),"H","")
T3:T15	T3	=RIGHT(R3,18)

So I need help getting iferror, index/match to find more than one answer. Example:
When iferror/index/match is executed it just shows one result and even if there is another one after that it stops there.

When it points to just "mov.call" for example, it can also point to "eventos" if there is also this match

in simpler terms: the search in the parameter "abcde" I'm looking for b-e, but it just shows me the "b" ignoring the "e" and I would like it to show all (being these 2 or more based on an index)

 

[Peter_SSs]

Duplicate to: How to get Multiples Match in one cell

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.