Fuzzymatch across thousands of columns/rows

[Lili1]

Good afternoon everyone, I need some help understanding how to use fuzzy match. I have six columns, Clientname1, Clientname2, Region1, Region2, Region3, and Region4. Clientname1 and clientname2 each contain about 500 client names. Each region contains between 30-4000 client names. What I want to do is see if clientname1 or 2 exist in each of the four regions, so returning what that best match is if there is one in each region. I tried transposing to get these across columns but saw that made things worse as none of the client names line up due to extra clients or missing clients in each region. I've attached an example of my data and my goal, any help is appreciated, thank you so much!

Current data format;

 Goal;

[jrlindem · Accepted solution]

Have you tried using the "Open Example" from the Fuzzy Match tool?  I think the "Business Name Example" is quite similar to what you're hoping to do...

Hope that helps get you started, -Jay