Fuzzy Match Help

Hello, All,

I am trying to match two lists of company names. Each list may contain duplicates that are identical (e.g. List #1 lists [I]Wells Fargo Securities, LLC[I] multiple times. However, each list may also repeat company names, but with slight differences. For example, in List #2, the company Zynga is listed as: Zynga Inc, Zynga Germany, and Zynga Game Network Inc. However, even though listed three times, this is only one company (for our purposes).

My problem: I want to find all companies in list #2 that match or "semi" match (fuzzy match?) companies listed in list #1. I want to return all matches and semi matches, not just the first or last match. Then, I want to list all entity IDs in column B to those matches so that I can pair each company in list #2 with one or more IDs and company names from list #1 (column D and column G are the same list - list #2 - since I was trying two different approaches).

Can you help me? I am not sure if a formula or VBA/macro is best. Also, if there is anyway to gauge a % or degree of match, that would be great (but not a necessity).

Thank you! I would love to learn how to do this, so any help you can give is most appreciated!

Thank you for this! I will look at it in more detail, but it seems like a great place to begin.

Have a great day!

Thank you for taking time to look at it. I will review what you sent. I very much appreciate your help!