Hi all,

I came across Fuzzy Lookup add-in for excel today, and thought it would come in handy since we have two different databases, and we need to link the data in them.
Mainly I have 4 columns from each database, 3 of them being strings, 1 of them numeric. The string data has many similarities, but slight differences in spelling, etc, so we're not matching exact same data.

Problem is, whenever I run Fuzzy Lookup, it stops after a few rows and gives the "excel range numberformat locale cannot be set" error.

My Windows system is set to Hungarian, Excel is also Hungarian. Tried changing the region and date / number format to english (US) but no luck, same error.

Does anyone know the solution to this error? It may not even be Fuzzy Lookup-related.

I have Office 2019.

Thanks in advance,
Alex