EXCEL Lookup Formula for Non-Exact Data values

[ldashev]

I have two tables that I need to match up. Each one contains same entities, but they could be listed different. What is the best way to capture them?

Column A
Vikings LTD
Soul Train Inc

Column B
Vikings Limited
Soul Tr Incorporated


Which formula would you recommend to bring back matching results? Meaning I want Column B to lookup in Column A and match Vikings Limited to Vikingds LTD. Is this possible?

Thank you!

 

[oldbrewer]

find LTD replace with Limited
find Tr replace with Train

etc for as many variants as you have

 

[ldashev]

What if I have 100's or 1000's of values....it becomes too manual. Looking to see if anyone has a way around it.

find LTD replace with Limited
find Tr replace with Train

etc for as many variants as you have

 

[oldbrewer]

if you try to use lookup table there will ALWAYS be wrong words returned

write a macro that first alters the ltd then the Tr then all the others and run it at the start of every day.......