Fuzzy Lookup Add-In For Excel Free Alternative Im
Fuzzy Lookup Add-In For Excel Install It Correctly

The problem is that many times the requested products are not described as the exact words as the names in my database.

Vlookup is not a good option, i have tried many variations of that formula and it only works acceptable sometimes.

It works very good, but its a payed software that will work only for a limited time.

Fuzzy Lookup Add-In For Excel Free Alternative Im

Anyone knows a free alternative Im sure it could be replicated with a macro, but i dont really understand VBA to be changing the code all time time in order to change accuracy.

Can anyone explain me if, it would be possible to code something like that and then be used as a formula, and in the formula define the accuracy level Im loving the tool, its exactlly what i was searching, but i would like a free solution at the moment.

Fuzzy Lookup Add-In For Excel Install It Correctly

At least that is what i think, like i said i was unable to install it correctly.

The fuzzy lookup will return as many comparisons for one text string in a list to the whole list of texts in another table column and give you the comparison score for each.

Youd then need to decide which of the comparisons you want to use - presumably the highest score (and in which case youd only get fuzzy lookup to return one comparison for each base string), then having chosen which comparison to use youd use a regular VLOOKUP (or perhaps an INDEX(MATCH()) combination to lookup that product name and return the relevant product code.

Fuzzy lookup is another, and a good one, solution for my problem.

If you feel I forgot you, remind me with a PM or just bump the thread.

I think i will use fuzzy vlookup add in, i just need to reinstall it in order to work.

You can get help to set that up in the VBA part of the forum, it shouldnt be a problem.

Fuzzy Lookup Add-In For Excel For Mac