Non identical match AKA Fuzzy Match

Hello everyone,

I'm facing a very complicated situation and I don't know how to solve it.
I've searched everywhere, sites, forums, asked Chat-GPT to write me some code on G-Sheet, bought a G-Sheet plug-ins but nothing works.

Here's my problem: I have 4 files

1) A complete database with 200,000 products in which I have this information: Brand, Title, Quantity and Bar-Code (important information)

2) I have 3 fiels with my reseller where each have 10 to 15,000 products which are sometimes the same for each reseller but not always, some resellers have products that only they resell.

Objective:

I want to import and therefore add the barcode present in file 1 to the 3 other files, which have no barcode.

A simple way would be to search for the product title (as Vlookup can do) in file 1 and match it in the 3 others, but this isn't possible as the names are different.
In fact, the problem is that these 3 retailers each have their own way of naming the same product.

Example: (I put a file in PJ > I used tabs)

Database: "Rulldeodorant Action Control Clinical, GARNIER, 50 ml".

Retailer 1: "Rulldeo.GARNIER Action Control 50ml"
Reseller 2: "Garnier mineral action Rulldeodorant 50ml"
Reseller 3: "Garnier Mineral Act.Control Clinical rulldeo 50ml"

So you can see that the 4 titles are quite different, and again it's much worse when the names are in English or whatever that's why Vlookup and others don't work.
Would it be possible to do this with a Macro?

Given that the Brand and Quantity columns are present for almost every product, this could increase the probability of a match.
Ideally, it would be great to know if there several results / occurrences for each match, as well as the statistical match probability (or ressemblance).

If anyone could help me do this it would be so great!
Thanks in advance

(English Version)

Good morning Sonny7,

I faced a very similar problem myself a while ago. Did you ever tried to use this add-in made by Microsoft?

Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center