2 Similar Column Comparison

[ExcelMac720]

Hey Everyone,

I have been searching excel forums endlessly for the answer to my problem. I have to sheets with companies in a column and information for specific companies in the adjacent rows. Each sheet has over 8,000 names on them. The company names between the two sheets tend to be written in a different way, so very few exact matches exist.

I know it is possible to search for 3-4 letters similar in a row to make a match, but I am not sure how. I would like the matching/similar companies to combine the information in the rows (creating more columns on one sheet). I would also like to separate the non matches some way that is visible (although this is less crucial). Thank you to anybody that can help or point me in the right direction!

 

[JamesCanale]

There is an add-in for excel from microsoft for fuzzy matches. I just found it and I'll see if I can download and install it on my computer.

Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center

The Fuzzy Lookup Add-In for Excel performs fuzzy matching of textual data in Excel.

www.microsoft.com

It could be helpful for you.

edit: I can't install it on my computer, it's an exe and I'm locked out of installing things.