Match partial texts with multiple returns

[Closed]
Report
Posts
1
Registration date
Monday August 20, 2012
Status
Member
Last seen
August 20, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
When it comes to partial match, you can use match and index to get you to closer. However some you would have to resolve manually as I may have
Company ABC Limited
Compary ABC Listed
Compary ABC Ltd

So now you have to make a call what two names are "similiar"