I have a master list of 3,000 names, and a second sheet that contains 150 names.



I would like to:

1. Highlight in 2nd sheet the names which can be found on the 1st sheet
2. Do a "contains" search rather than exact search on the name to get a hit.
For example, it should ignore spaces, recognize abbreviations (e.g. ltd = limited), or ignore the end of the name (private limited, or whatever I define to be irrelevant).


How do I go about doing this? If there is no ready-made solution, I can at least settle for a direct+exact match first (figured it'd be less complicated than what I need).

Thanks in advance for your help!