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.

DisplayName Ross Eustace Geller Rachel Green Joey Francis Tribbiani Jr. Monica E Geller Chandler Muriel Bing Bing Phoebe Buffay <tbody> </tbody>

<tbody>
</tbody>

In another sheet I have this in Y:

FULL NAME

CHANDLER MURIEL BING BING

RACHEL KAREN GREEN SECOND

JOSEPH JOEY FRANCIS TRIBBIANI JR

PHOEBE NOMIDDLE BUFFAY NOSECOND

ROSS EUSTACE GELLER ANYSECOND

MONICA MIDDLEE GELLER BING

<tbody>
</tbody>

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

	A	B
1	Name	Full Name
2	Ross Eustace Geller	ROSS EUSTACE GELLER ANYSECOND
3	Rachel Green	RACHEL KAREN GREEN SECOND
4	Joey Francis Tribbiani Jr.	JOSEPH JOEY FRANCIS TRIBBIANI JR
5	Monica E Geller	MONICA MIDDLEE GELLER BING
6	Chandler Muriel Bing Bing	CHANDLER MURIEL BING BING
7	Phoebe Buffay	PHOEBE NOMIDDLE BUFFAY NOSECOND

<tbody>
</tbody>

CELL	FORMULA
B2	=VLOOKUP("*" & SUBSTITUTE(SUBSTITUTE(A2,".","")," ","*") & "*",sheet2!Y:Y,1,0)

<tbody>
</tbody>