I need to match two tables based on the name of a company. Each table refers to the company differently. I am wondering if there is a way to match two tables using the closest match possible between the names . For instance
Table A refers to one company as " Storm Ventures International"
Table B refers to the same company as " Storm International(Barbados)Ltd "
Another match would be in Table A " Uglegorsk-Tsement "
in Table B " ZAO Uglegorsk-Tsement "
I am wondering how can I make match the two tables based on the closest match?