Need to find partial matches between two columns

**rockportag03** · 11-04-2010, 03:55 PM

Column A is a list of 1400 company names.

Column B is a list of 1200 company names.

I want to see which of the company names in Column B also exist in Column A.

Same company names are not necessarily exact matches between Columns A & B.

Example:

Column A*********************Column B
Joe's Tire Shop**************A&D Pawn Co.
A & D Pawn*****************Joes Tire Shop, Inc

How can I identify, in Column C, which of the company names in Column B, already exist in Column A?

**alansidman** · 11-04-2010, 05:30 PM

I did a search on "Fuzzy Match Excel" in Google and found several hits. Here is one of them. You may want to look at others also.

http://www.digdb.com/excel_add_ins/m...columns_fuzzy/

Alan

**rockportag03** · 11-04-2010, 06:23 PM

I am not familiar with VBA code and I was hoping that someone might have a formula that I could put in C1 and drag down alongside the COLUMN B entries which are being compared to the COLUMN A list.

**alansidman** · 11-05-2010, 08:25 AM

If you follow the instructions provided for using VBA, you will ordinarily get to where you need to be. What you are asking for is a multi step procedure and if your file has hundreds or thousands of names you will need to do it in VBA. If it is only a few names, then you don't need excel at all because you could do it with your eye. Try it out and post back when you hit a stumbling block. Lots of smart people in this forum that will help you along but you do need to put some effort into the exercise.

Alan