Tricky two Column Comparison: Words in one cell/column with names in other cell/column

[actjfc]

Excel friends,

This problem looks like “easy” but I decided to ask the experts. I have two lists: both with company names. Names were input in different word order or adding different words to very similar names. I need to identify the occurrences and position of any of the words in each name in List A when they show up in any of the names in List B. For example: American Motor Specialists in List A, row 500, may show up in List B as Specialists American Engine, Co., row 750. These names may be the same company, it just need a further "manual" check to verify it, first thing is to ID the occurrences. Name and row of the occurrences ¿Is there a way to do it? Any ideas? VBA code?

List A and B contain about 1000 names, and it is a monthly repetitive task.

Any help is appreciated. Thanks!

 

[pplstuff]

Sounds like you may be screwed. You'll need some sort of way to say: American Motor Specialists = Specialists American Engine, Co. and have all possible outcomes for every name. You could try an match one word - but it'd be very time consuming to find that unique word in every record.

This sounds like a job that should be done in Access instead of Excel. You'll have to develop the relational aspect in a separate table, and the use queries to return your desired results.

 

[actjfc]

I found this external link, it is not exactly what I need, but it is an start, maybe MA Access it is more efficient.

[SOLVED] find word(s) within text string that matches a list of keywords

Any other ideas?

Thansk!