How to search a column for a list of 20 different names

[BG1983]

Hi, I have got a list of search strings, lets say Search String 1, Search String 2, Search String 3, etc.

and I need to look for each for each search string in column a, and if found, return that search string name in column b

Attached is an example -- Sheet2 has 20 search strings I am looking for

Sheet1 - Column A has the data I need to search in (i only included 5 examples -- i think thats enough for you guys to get the idea)

Sheet1 - Column B shows my desired output

What formula, or vba can I use to do this? (Note: The column will contain around 2,000 items to search (column A in this example) and there will be around 30 search strings that I am looking for)


Thanks for your help!