I have a list of data in one column (call it column A) that includes football transfers from 2015 e.g. "Jayden Stockley (AFC;Bournemouth - Portsmouth)". These have players names in them but also their respective team before and after transfer within each cell.

I have a second list of data (call it column B) of several hundred football players, with no teams, just their names e.g. "Jayden Stockley", "Rob Jones", "Peter Drury".

I would like to find any transfer that in is column A that includes any of the names from column B (not an exact match because column B will not have the teams or brackets, just the name).

If I were doing it manually I would highlight column A and hit ctrl + F and type in each players name from column B one by one and then see if they made a transfer, but there must be a way of the search looping through list B without me typing them one by one.

Ultimately I want a copied list that includes only transfers from column A that is of players in column B so I don't know if its easiest to find matches and then manually copy and paste into a new area of the spreadsheet or if a formula could copy the cell if it is a transfer that is of a player from column B.

Thanks in advance for help, apologies I couldn't find out how to do this from other posts.