Search names from a column to another and output the common name

Question

Hello,

Could you, please help me? I want to check the AR_ Name column in the Client column and keep the common matching text (50-60% matching ). Moreover, if inside the AR_ Name clients have a similar name  and if they do not match at all with the Client column, should return the AR_ Name. This should be applicable only for the AR_ name column not null/empty. Thanks a lot!

community.xlsx

alexnajm · Accepted Answer

If you are looking for a percent match, then Fuzzy Match is the tool for you! Tool Mastery | Fuzzy Match correspondance partielle fuzzyübereinstimmung

But I would say these are nowhere close to matching... so this will be a challenge

jrlindem · Accepted Answer

I also took a look at this and played around with the Fuzzy Match, but couldn't get it to produce your expected results.  I do think Fuzzy Match is the right method as @alexnajm pointed out, but your either going to need to configure your own matching rules or you're going to need to see what you can do to the data upstream to get it closer to aligning...  -Jay