How to get Multiples Match in one cell

[lu1zuk]

Sobe_e_Desce_2.0.xlsx
	A	B		D	E	F	G	H	I		K	L	M	N	O	P	Q	R	S	T	U
2	Usuário	Tempo		Cargos	Separador		Horas	Separador	Qual a Equipe?		Ids	Qual a Equipe?								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	161	|||	Equipe Mov.Call		<@229456993373519872>	Equipe Mov.Call							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	141	|||	Equipe Registro		<@755287807337169017>	Equipe Registro							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	133	|||	Equipe Mov.Call		<@960299650810794004>	Equipe Mov.Call							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	127	|||	Equipe Eventos		<@961772149956309079>	Equipe Eventos							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	124	|||	Auxiliar Eventos		<@858781483149819945>	Auxiliar Eventos							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	122	|||	Equipe Mov.Call		<@931988559970332704>	Equipe Mov.Call							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	122	|||	Equipe Recrutamento		<@966333127716909118>	Equipe Recrutamento							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	121	|||	Equipe Mov.Call		<@370612816291561474>	Equipe Mov.Call							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	120	|||	Equipe Mov.Call		<@906573722838761562>	Equipe Mov.Call							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	118	|||	Equipe Mov.Call		<@667095822101512194>	Equipe Mov.Call							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	112	|||	Equipe Mov.Call		<@692180947990216725>	Equipe Mov.Call							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	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	81	|||	Equipe Registro		<@795107916989857812>	Equipe Registro							993257880927076392	Equipe Games	993257880927076392
Planilha1

Cell Formulas
Range	Formula
F3:F15	F3	=LEFT(B3,3)
G3:G15	G3	=--SUBSTITUTE(F3,"H","")
I3:I15	I3	=IFERROR(@INDEX(T$3:T$15,AGGREGATE(15,6,(ROW(T$3:T$15)-ROW(U$3)+1)/ISNUMBER(SEARCH(U$3:U$15,D3)),1)),"")
K3:K15	K3	=CONCAT("<@",J3,">")
L3:L15	L3	=IFERROR(@INDEX(T$3:T$15,AGGREGATE(15,6,(ROW(T$3:T$15)-ROW(T$3)+1)/ISNUMBER(SEARCH(U$3:U$15,D3)),1)),"")
U3:U15	U3	=RIGHT(S3,18)

Tryind to use INDEX - MATCH and IFERROR to find in a location X results. The results im trying to find is " ID " that will result in " Equipe " and it will match from "Cargos" , but i dont know how to make it show multiple matchs, so how can i do it? tryed googling but i dont know the right terms for in english and in my language (pt-br) it doesnt has that much info

 

[lu1zuk]

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)
(just using a better explanation if the one in the post is confuse)

 

[KRice]

Can you clarify something, please? For the first row of data, is this the expected result you want?

Equipe Eventos, Auxiliar Eventos, Equipe Mov.Call, Equipe Recrutamento, Equipe Divulgação, Equipe CDC, Equipe Registro, Equipe Design, Equipe Hot, Equipe EXAFLIX​

Cell D3 contains 38 different numeric "text" strings (each consisting of 18 characters). It appears that you have a lookup table in columns T:U, and if we extract the first 15 characters of all of the ID's shown in column U and look for whether they can be found in cell D3, we discover that 10 of them match. Those are the 10 shown above. Is this what you want? If so, INDEX/MATCH will not work because MATCH returns only the first match. With your version of Excel (2019), an approach using INDEX/AGGREGATE is probably the best way, but there are some limitations that need to be addressed. Excel versions 2019 and prior do not have a convenient way to concatenate multiple results with a formula without using helper cells. And even then, the concatenate functionality is not very good because there are no options for inserting delimiters (or separators). This can be addressed by using a custom function added to your workbook (right click on worksheet tab, select View Code, then add a module to the worksheet and pasts the VBA code into the module and close the VBA window). This creates a user-defined function called ACONCAT that allows you to input a range of helper cells to concatenate and to specify a separator.

I used this formula in cell V3 and then dragged across to AJ3. This places successive matches in each column until no more matches are found and then blanks will be produced:

=IFERROR(INDEX($T$3:$T$15,AGGREGATE(15,6,(ROW($T$3:$T$15)-ROW($T$3)+1)/ISNUMBER(SEARCH(LEFT($U$3:$U$15,15),$D3)),IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($U$3:$U$15,15),$D3))),COLUMNS($V3:V3),""))),"")

After confirming that blanks are produced (so all results are shown), the ACONCAT function is used to combine all of them.

=aconcat(V3:AJ3,", ")

Function aconcat(a As Variant, Optional sep As String = "") As String
' Harlan Grove, Mar 2002, original version without conditional y<>""
' Kirk Rice, Apr 2022, added conditional y<>"" to ignore blanks in array a
    Dim y As Variant


    If TypeOf a Is Range Then
        For Each y In a.Cells
            If y <> "" Then
            aconcat = aconcat & y.Value & sep
            End If
        Next y
    ElseIf IsArray(a) Then
        For Each y In a
            If y <> "" Then
            aconcat = aconcat & y & sep
            End If
        Next y
    Else
        aconcat = aconcat & a & sep
    End If


    aconcat = Left(aconcat, Len(aconcat) - Len(sep))
End Function

 

[lu1zuk]

Can you clarify something, please? For the first row of data, is this the expected result you want?

Equipe Eventos, Auxiliar Eventos, Equipe Mov.Call, Equipe Recrutamento, Equipe Divulgação, Equipe CDC, Equipe Registro, Equipe Design, Equipe Hot, Equipe EXAFLIX​

Cell D3 contains 38 different numeric "text" strings (each consisting of 18 characters). It appears that you have a lookup table in columns T:U, and if we extract the first 15 characters of all of the ID's shown in column U and look for whether they can be found in cell D3, we discover that 10 of them match. Those are the 10 shown above. Is this what you want? If so, INDEX/MATCH will not work because MATCH returns only the first match. With your version of Excel (2019), an approach using INDEX/AGGREGATE is probably the best way, but there are some limitations that need to be addressed. Excel versions 2019 and prior do not have a convenient way to concatenate multiple results with a formula without using helper cells. And even then, the concatenate functionality is not very good because there are no options for inserting delimiters (or separators). This can be addressed by using a custom function added to your workbook (right click on worksheet tab, select View Code, then add a module to the worksheet and pasts the VBA code into the module and close the VBA window). This creates a user-defined function called ACONCAT that allows you to input a range of helper cells to concatenate and to specify a separator.

I used this formula in cell V3 and then dragged across to AJ3. This places successive matches in each column until no more matches are found and then blanks will be produced:

=IFERROR(INDEX($T$3:$T$15,AGGREGATE(15,6,(ROW($T$3:$T$15)-ROW($T$3)+1)/ISNUMBER(SEARCH(LEFT($U$3:$U$15,15),$D3)),IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($U$3:$U$15,15),$D3))),COLUMNS($V3:V3),""))),"")

After confirming that blanks are produced (so all results are shown), the ACONCAT function is used to combine all of them.

=aconcat(V3:AJ3,", ")

Function aconcat(a As Variant, Optional sep As String = "") As String
' Harlan Grove, Mar 2002, original version without conditional y<>""
' Kirk Rice, Apr 2022, added conditional y<>"" to ignore blanks in array a
    Dim y As Variant


    If TypeOf a Is Range Then
        For Each y In a.Cells
            If y <> "" Then
            aconcat = aconcat & y.Value & sep
            End If
        Next y
    ElseIf IsArray(a) Then
        For Each y In a
            If y <> "" Then
            aconcat = aconcat & y & sep
            End If
        Next y
    Else
        aconcat = aconcat & a & sep
    End If


    aconcat = Left(aconcat, Len(aconcat) - Len(sep))
End Function

Answering your questions in order: Yes the results I would like based on the 18 groups of numbers each with their corresponding identifier in left -> right order. so the answer is yes

But about the using

=IFERROR(INDEX($T$3:$T$15,AGGREGATE(15,6,(ROW($T$3:$T$15)-ROW($T$3)+1)/ISNUMBER(SEARCH(LEFT($U$3:$U$15,15),$D3)),IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($U$3:$U$15,15),$D3))),COLUMNS($V3:V3),""))),"")

I don't understand very well, there are some things out of place, right? Would you mean this?

=IFERROR(INDEX($S$3:$S$15;AGGREGATE(15;6;(ROW($S$3:$S$15)-ROW($S$3)+1)/ISNUMBER(SEARCH(LEFT($T$3:$T$15;15);$D3));IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($T$3:$T$15;15);$D3)));COLUMNS($V3:V3);"")));"")

with the right columns, because in yours the parameters (line/columns) were a little to the right ?
I made one using yours without changing anything and then I made one changing just for the sake of clearing my doubt, but coming to ask directly because I'm on a path that I know very little

Sobe_e_Desce_2.0.xlsx
	O	P	Q	R	S	T
3	Equipe Eventos	869353363815411757		869353363815411757	Equipe Eventos	869353363815411757
4				869353363815411758	Auxiliar Eventos	869353363815411758
5				869353363815411754	Equipe Mov.Call	869353363815411754
6				869353363815411756	Equipe Recrutamento	869353363815411756
7				869353363815411755	Equipe Divulgação	869353363815411755
8				869353363815411752	Equipe CDC	869353363815411752
9				869353363815411753	Equipe Registro	869353363815411753
10				973715650528833598	Equipe Suporte	973715650528833598
11				869353363807010855	Equipe Design	869353363807010855
12				869353363807010854	Equipe Hot	869353363807010854
13				896811812132110336	Equipe EXAFLIX	896811812132110336
14				962805646099640340	Equipe Jornalismo	962805646099640340
15				993257880927076392	Equipe Games	993257880927076392
Planilha1

Cell Formulas
Range	Formula
O3	O3	=IFERROR(INDEX($S$3:$S$15,AGGREGATE(15,6,(ROW($S$3:$S$15)-ROW($S$3)+1)/ISNUMBER(SEARCH(LEFT($T$3:$T$15,15),$D3)),IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($T$3:$T$15,15),D3))),COLUMNS($V3:V3),""))),"")
P3	P3	=IFERROR(INDEX($T$3:$T$15,AGGREGATE(15,6,(ROW($T$3:$T$15)-ROW($T$3)+1)/ISNUMBER(SEARCH(LEFT($U$3:$U$15,15),$D3)),IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($U$3:$U$15,15),$D3))),COLUMNS($V3:V3),""))),"")
T3:T15	T3	=RIGHT(R3,18)

But yes, based on the 18-character set, if they match the exact 18 in table T then it will point out that the one on the left in table S is its counterpart.

869353363815411757
= Equipe Eventos
and so susceptibly

 

[KRice]

In post #1, you show the Equipe list in column T and the corresponding IDs in column U...which is what my formula assumes. In your most recent post #4, that same information is in columns S and T, so some adjustment to the formula will be needed if the structure of the table has changed. The other difference shown in the formula in post #4 involves this expression: (ROW($S$3:$S$15)-ROW($S$3)+1).
It does not matter which column you reference here, but I will recommend that you should use a column related to your lookup table. The only purpose of this part of the formula is to create an array that looks like {1;2;3;...last index of lookup table}. You can accomplish this by using any of the columns.

Could you repost a mini-sheet showing what the results should look like for row 3...just manually type what the results are and where you would like them to appear...without worrying about any formulas. I still do not completely understand what is to be returned by the formula(s)?

 

[lu1zuk]

****, sorry, you based on the first one, I'm sorry, it's just that I made some adjustments and for some reason I can't find the button to edit the post anymore. Here's how I'm currently using it

Sobe_e_Desce_2.0.xlsx
	A	B		D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
2	Usuário	Tempo		Cargos	Separador	Horas	Separador	Qual a Equipe?	Id	Ids		On h3 what is the result i'm looking for: in the d3 has sets of 18 characteres							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	<@229456993373519872>		in the h3 should show something like (below)			Equipe Eventos	869353363815411757		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	<@755287807337169017>	D3 ->	Equipe Mov.Call, Equipe Divulgaçao, Equipe Exaflix						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	<@960299650810794004>	D4 ->	Equipe Registro, Equipe Design, Equipe Games						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	<@961772149956309079>	goes on and on	goes on and on						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	<@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	<@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	<@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	<@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	<@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	<@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	<@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	<@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	<@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)),"")
I3:I15	I3	=RIGHT(A3,18)
J3:J15	J3	=CONCAT("<@",I3,">")
O3	O3	=IFERROR(INDEX($S$3:$S$15,AGGREGATE(15,6,(ROW($S$3:$S$15)-ROW($S$3)+1)/ISNUMBER(SEARCH(LEFT($T$3:$T$15,15),$D3)),IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($T$3:$T$15,15),D3))),COLUMNS($V3:V3),""))),"")
P3	P3	=IFERROR(INDEX($T$3:$T$15,AGGREGATE(15,6,(ROW($T$3:$T$15)-ROW($T$3)+1)/ISNUMBER(SEARCH(LEFT($U$3:$U$15,15),$D3)),IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($U$3:$U$15,15),$D3))),COLUMNS($V3:V3),""))),"")
F3:F15	F3	=--SUBSTITUTE(LEFT(B3,3),"H","")
T3:T15	T3	=RIGHT(R3,18)

And I already manually put the answer as you asked, what is my goal, one of the goals at least

 

[KRice]

Cell D3 contains this list of ID's:
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

The lookup table appears to be in columns R:S, shown here:

	Equipe
869353363815411000	Equipe Eventos
869353363815411000	Auxiliar Eventos
869353363815411000	Equipe Mov.Call
869353363815411000	Equipe Recrutamento
869353363815411000	Equipe Divulgação
869353363815411000	Equipe CDC
869353363815411000	Equipe Registro
973715650528833000	Equipe Suporte
869353363807010000	Equipe Design
869353363807010000	Equipe Hot
896811812132110000	Equipe EXAFLIX
962805646099640000	Equipe Jornalismo
993257880927076000	Equipe Games

I have shown in color how the contents of cell D3 match to certain items in the lookup table column R, and the corresponding Equipe items from column S are returned. But in your manually filled in example, you indicate that only three items should match: Equipe Mov.Call, Equipe Divulgaçao, Equipe Exaflix
Why is that, when the first 7 items in the lookup table have the same ID? Should not all of these be considered matches?

Equipe Eventos, Auxiliar Eventos, Equipe Mov.Call, Equipe Recrutamento, Equipe Divulgação, Equipe CDC, Equipe Registro, Equipe Design, Equipe Hot, Equipe EXAFLIX​

Here is the right side of the worksheet:

MrExcel_20220704d.xlsm
	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
1
2
3	Equipe Eventos	Auxiliar Eventos	Equipe Mov.Call	Equipe Recrutamento	Equipe Divulgação	Equipe CDC	Equipe Registro	Equipe Design	Equipe Hot	Equipe EXAFLIX
4	Equipe Eventos	Auxiliar Eventos	Equipe Mov.Call	Equipe Recrutamento	Equipe Divulgação	Equipe CDC	Equipe Registro	Equipe Design	Equipe Hot	Equipe EXAFLIX
Planilha1

Cell Formulas
Range	Formula
V3:AJ4	V3	=IFERROR(INDEX($S$3:$S$15,AGGREGATE(15,6,(ROW($S$3:$S$15)-ROW($S$3)+1)/ISNUMBER(SEARCH(LEFT($T$3:$T$15,15),$D3)),IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($T$3:$T$15,15),$D3))),COLUMNS($V3:V3),""))),"")

And here is the left side:

MrExcel_20220704d.xlsm
	A	B	C	D	E	F	G	H
1
2	Usuário	Tempo		Cargos	Separador	Horas	Separador	Qual a Equipe?
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 Eventos, Auxiliar Eventos, Equipe Mov.Call, Equipe Recrutamento, Equipe Divulgação, Equipe CDC, Equipe Registro, Equipe Design, Equipe Hot, Equipe EXAFLIX
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 Eventos, Auxiliar Eventos, Equipe Mov.Call, Equipe Recrutamento, Equipe Divulgação, Equipe CDC, Equipe Registro, Equipe Design, Equipe Hot, Equipe EXAFLIX
Planilha1

Cell Formulas
Range	Formula
F3:F4	F3	=--LEFT(B3,SEARCH(" Horas",B3)-1)
H3:H4	H3	=aconcat(V3:AJ3,", ")

 

[lu1zuk]

Cell D3 contains this list of ID's:
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

The lookup table appears to be in columns R:S, shown here:

	Equipe
869353363815411000	Equipe Eventos
869353363815411000	Auxiliar Eventos
869353363815411000	Equipe Mov.Call
869353363815411000	Equipe Recrutamento
869353363815411000	Equipe Divulgação
869353363815411000	Equipe CDC
869353363815411000	Equipe Registro
973715650528833000	Equipe Suporte
869353363807010000	Equipe Design
869353363807010000	Equipe Hot
896811812132110000	Equipe EXAFLIX
962805646099640000	Equipe Jornalismo
993257880927076000	Equipe Games

I have shown in color how the contents of cell D3 match to certain items in the lookup table column R, and the corresponding Equipe items from column S are returned. But in your manually filled in example, you indicate that only three items should match: Equipe Mov.Call, Equipe Divulgaçao, Equipe Exaflix
Why is that, when the first 7 items in the lookup table have the same ID? Should not all of these be considered matches?

Equipe Eventos, Auxiliar Eventos, Equipe Mov.Call, Equipe Recrutamento, Equipe Divulgação, Equipe CDC, Equipe Registro, Equipe Design, Equipe Hot, Equipe EXAFLIX​

Here is the right side of the worksheet:

MrExcel_20220704d.xlsm
	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
1
2
3	Equipe Eventos	Auxiliar Eventos	Equipe Mov.Call	Equipe Recrutamento	Equipe Divulgação	Equipe CDC	Equipe Registro	Equipe Design	Equipe Hot	Equipe EXAFLIX
4	Equipe Eventos	Auxiliar Eventos	Equipe Mov.Call	Equipe Recrutamento	Equipe Divulgação	Equipe CDC	Equipe Registro	Equipe Design	Equipe Hot	Equipe EXAFLIX
Planilha1

Cell Formulas
Range	Formula
V3:AJ4	V3	=IFERROR(INDEX($S$3:$S$15,AGGREGATE(15,6,(ROW($S$3:$S$15)-ROW($S$3)+1)/ISNUMBER(SEARCH(LEFT($T$3:$T$15,15),$D3)),IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($T$3:$T$15,15),$D3))),COLUMNS($V3:V3),""))),"")

And here is the left side:

MrExcel_20220704d.xlsm
	A	B	C	D	E	F	G	H
1
2	Usuário	Tempo		Cargos	Separador	Horas	Separador	Qual a Equipe?
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 Eventos, Auxiliar Eventos, Equipe Mov.Call, Equipe Recrutamento, Equipe Divulgação, Equipe CDC, Equipe Registro, Equipe Design, Equipe Hot, Equipe EXAFLIX
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 Eventos, Auxiliar Eventos, Equipe Mov.Call, Equipe Recrutamento, Equipe Divulgação, Equipe CDC, Equipe Registro, Equipe Design, Equipe Hot, Equipe EXAFLIX
Planilha1

Cell Formulas
Range	Formula
F3:F4	F3	=--LEFT(B3,SEARCH(" Horas",B3)-1)
H3:H4	H3	=aconcat(V3:AJ3,", ")

R:S No, S:T because if you use the R table, it won't get the correct 18 characters, because EXCEL keeps rounding, so I used R to put a ' (single quotes) at the beginning of the 18 numbers to that it didn't do that rounding, and so in column T I use the right to get the 18 characters from right to left, for that reason you're thinking that more than just 3 are located there, because these ids are tags, the tags were created around the same day or even on the same day causing many of their numbers to be the same to some extent, but if you notice, in the table I sent R is just for a function of T, where T is the right one for the search, your search is showing more than the 3 shown in my manual because you ended up using the wrong table, which is the R, while the correct one with the 18 characters without rounding is the T

For example, in D3, you yourself pointed there, coloring, only 3 options were found (but for some reason you only colored 15 of the 18 set of numbers) but if you search manually with the naked eye or then for example using CTRL+F from browsing and trying to find Team events = 869353363815411757, it will not show there in those D3 sets, and when played in excel it will but it is not really there

 

[lu1zuk]

I just changed one thing and it worked fine!

=IFERROR(INDEX($S$3:$S$15;AGGREGATE(15;6;(ROW($S$3:$S$15)-ROW($S$3)+1)/ISNUMBER(SEARCH(LEFT($T$3:$T$15;18);$D3));IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($T$3:$T$15;15);$D3)));COLUMNS($V3:V3);"")));"")

in the 15 on the (search(left)), i put in 18 and worked

Sobe_e_Desce_2.0.xlsx
	A	B		D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
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	<@229456993373519872>		in the h3 should show something like (below)			Equipe Eventos	869353363815411757		869353363815411757	Equipe Eventos	869353363815411757		Equipe Mov.Call	Equipe Divulgação	Equipe EXAFLIX
Planilha1

Cell Formulas
Range	Formula
F3	F3	=--SUBSTITUTE(LEFT(B3,3),"H","")
H3	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)),"")
I3	I3	=RIGHT(A3,18)
J3	J3	=CONCAT("<@",I3,">")
O3	O3	=IFERROR(INDEX($S$3:$S$15,AGGREGATE(15,6,(ROW($S$3:$S$15)-ROW($S$3)+1)/ISNUMBER(SEARCH(LEFT($T$3:$T$15,15),$D3)),IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($T$3:$T$15,15),D3))),COLUMNS($V3:V3),""))),"")
P3	P3	=IFERROR(INDEX($T$3:$T$15,AGGREGATE(15,6,(ROW($T$3:$T$15)-ROW($T$3)+1)/ISNUMBER(SEARCH(LEFT($U$3:$U$15,15),$D3)),IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($U$3:$U$15,15),$D3))),COLUMNS($V3:V3),""))),"")
T3	T3	=RIGHT(R3,18)
V3:Z3	V3	=IFERROR(INDEX($S$3:$S$15,AGGREGATE(15,6,(ROW($S$3:$S$15)-ROW($S$3)+1)/ISNUMBER(SEARCH(LEFT($T$3:$T$15,18),$D3)),IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($T$3:$T$15,15),$D3))),COLUMNS($V3:V3),""))),"")

 

[KRice]

if you use the R table, it won't get the correct 18 characters, because EXCEL keeps rounding, so I used R to put a ' (single quotes) at the beginning of the 18 numbers to that it didn't do that rounding,

I do not understand this point. R3 and T3 contain exactly the same value: 869353363815411000. Excel is only rounding the appearance of the number in R3, converting it to scientific notation, but the underlying number is still present. By adding a single quote (') in front, you are converting this number to a text string...which is fine, but unnecessary. The RIGHT function is a text function, and when a number is passed to it, the number will automatically be treated as a text string. So RIGHT(R3,10), if applied to the number 869353363815411000 in R3, would return 3815411000 as a text string. So the additional steps that you are talking about can be eliminated.

and so in column T I use the right to get the 18 characters from right to left, for that reason you're thinking that more than just 3 are located there

But if you get 18 characters from right to left, that is the entire number, or text representation of the number: 869353363815411000 has a string length of 18. Importantly, it ends with 000 and there are no numeric text strings in column D that contain 000...so there will be no matches. That is why I assumed your original formula, where you were taking 18 characters, must be a mistake. There are no common ID's between column D and columns R/T, and because of that, no matches will be found.

your search is showing more than the 3 shown in my manual because you ended up using the wrong table, which is the R, while the correct one with the 18 characters without rounding is the T

This is not correct. As described above, there is no difference between using column R or column T.

I cannot reproduce your results in post #9. Are you using different numbers in column R? The result in cell V3 shows a blank because no matches are found:

MrExcel_20220704d.xlsm
	D														R	S	T	U	V
1
2	Cargos															Equipe	ID
3	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														869353363815411000	Equipe Eventos	869353363815411000
4															869353363815411000	Auxiliar Eventos	869353363815411000
5															869353363815411000	Equipe Mov.Call	869353363815411000
6															869353363815411000	Equipe Recrutamento	869353363815411000
7															869353363815411000	Equipe Divulgação	869353363815411000
8															869353363815411000	Equipe CDC	869353363815411000
9															869353363815411000	Equipe Registro	869353363815411000
10															973715650528833000	Equipe Suporte	973715650528833000
11															869353363807010000	Equipe Design	869353363807010000
12															869353363807010000	Equipe Hot	869353363807010000
13															896811812132110000	Equipe EXAFLIX	896811812132110000
14															962805646099640000	Equipe Jornalismo	962805646099640000
15															993257880927076000	Equipe Games	993257880927076000
Sheet1

Cell Formulas
Range	Formula
V3	V3	=IFERROR(INDEX($S$3:$S$15,AGGREGATE(15,6,(ROW($S$3:$S$15)-ROW($S$3)+1)/ISNUMBER(SEARCH(LEFT($T$3:$T$15,18),$D3)),IF(COLUMNS($V3:V3)<=SUM(--ISNUMBER(SEARCH(LEFT($T$3:$T$15,15),$D3))),COLUMNS($V3:V3),""))),"")
T3:T15	T3	=RIGHT(R3,18)