Search strings and return the found

[Panchistiko]

Hi, team...
How can I find these simple names within the full names and return the result?

In Sheet1 I have this in A.

<tbody>
[TD="class: xl66"]

<tbody>
[TD="class: xl65"] DisplayName [/TD]

[TD="class: xl66"]Ross Eustace Geller[/TD]

[TD="class: xl66"]Rachel Green[/TD]

[TD="class: xl66, width: 170"]Joey Francis Tribbiani Jr.[/TD]

[TD="class: xl66, width: 170"]Monica E Geller[/TD]

[TD="class: xl66, width: 170"]Chandler Muriel Bing Bing[/TD]

[TD="class: xl66, width: 170"]Phoebe Buffay[/TD]

</tbody>

[/TD]

</tbody>

In another sheet I have this in Y:
[TABLE="width: 256"]
<tbody>[TR]
[TD]FULL NAME[/TD]
[/TR]
[TR]
[TD]CHANDLER MURIEL BING BING[/TD]
[/TR]
[TR]
[TD]RACHEL KAREN GREEN SECOND[/TD]
[/TR]
[TR]
[TD]JOSEPH JOEY FRANCIS TRIBBIANI JR[/TD]
[/TR]
[TR]
[TD]PHOEBE NOMIDDLE BUFFAY NOSECOND[/TD]
[/TR]
[TR]
[TD]ROSS EUSTACE GELLER ANYSECOND[/TD]
[/TR]
[TR]
[TD]MONICA MIDDLEE GELLER BING[/TD]
[/TR]
</tbody>[/TABLE]


I need to search the names in Sheet1 A within Sheet2 Y.
For example, A2 matches Y6, and A7 matches Y5.
If this happens, put Y value in Sheet1 B.

How can I do this?

 

[DanteAmor]

Sheet1
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: center"]Name[/TD]
[TD="align: center"]Full Name[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Ross Eustace Geller[/TD]
[TD]ROSS EUSTACE GELLER ANYSECOND[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Rachel Green[/TD]
[TD]RACHEL KAREN GREEN SECOND[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Joey Francis Tribbiani Jr.[/TD]
[TD]JOSEPH JOEY FRANCIS TRIBBIANI JR[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Monica E Geller[/TD]
[TD]MONICA MIDDLEE GELLER BING[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Chandler Muriel Bing Bing[/TD]
[TD]CHANDLER MURIEL BING BING[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Phoebe Buffay[/TD]
[TD]PHOEBE NOMIDDLE BUFFAY NOSECOND[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]CELL[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]B2[/TD]
[TD]=VLOOKUP("*" & SUBSTITUTE(SUBSTITUTE(A2,".","")," ","*") & "*",sheet2!Y:Y,1,0)[/TD]
[/TR]
</tbody>[/TABLE]