Match partial texts with multiple returns

Hello,

I have 2 sets of information:

1 simple list of Company Names ( Data-A )
1 array of data including another list of company names ( Data-B )

The company names in Data-A and Data-B will sometimes only be partial matches ( i.e. "Company ABC Incorporated" in Data-A may be "Company ABC Inc." in Data-B ).

There might also be several partial matches in Data-B ( i.e. "Company ABC Inc.", "Company ABC Inc", "Company ABC", etc ).

Ultimately, I'm looking to use the Data-A list to bring back the full row, or some sub-set of that data, in Data-B where there is a reasonable match.

If I use MATCH function on a sub-string of Data-A ( i.e. LEFT(Data-A,11) to get "Company ABC", how will it behave if there are multiple "Company ABC" entries in Data-B?


Any help is appreciated.

Thanks in advance,
Scott.