Compare strings

Registration date
Tuesday March 19, 2019
Last seen
March 19, 2019
- Mar 19, 2019 at 10:55 PM
Hello there,
Case: I have lists of customers from 2 different sources, however example. List1 says ABC private limited on row A1, the other list2 says xyzABC limited, suppose at Column row B294, both may vary the indexing, query: I need a common match to extract out at C1 for A1 string, I do not know, which word or partial word may match from both the list. In that case, computer should decide! The best match and give me the result. You can send me VB Code or excel formula. The other approach having loop, comparing full string first, than first, second, nth word with list2. Hope you understand the query. Thank you in advance for your great functionality and consideration, regards