I need to compare two rows that don't match on length. It's a list of companies that two departments deal with at my business.
list 1 has a long list of companies and list 2 has a list of companies. I need to find out which companies on list 2 are also on list 1, but the tricky part is they don't exactly match bc they are hand written. For example the company on list 1 will be "99(cent symbol) store" and on list 2 it will be "99 cent store" or it will be "3M Company" on list 1 but "3M" on list 2. How can I go through a loop of each company and compare to see if they are alike?
Anymore info or clarification needed please let me know.
list 1 has a long list of companies and list 2 has a list of companies. I need to find out which companies on list 2 are also on list 1, but the tricky part is they don't exactly match bc they are hand written. For example the company on list 1 will be "99(cent symbol) store" and on list 2 it will be "99 cent store" or it will be "3M Company" on list 1 but "3M" on list 2. How can I go through a loop of each company and compare to see if they are alike?
Anymore info or clarification needed please let me know.
