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
Bookmarks