Fuzzy Lookup

Hi there,

I am currently using the add-in Fuzzy Lookup and it works well. It works very well except on one thing: I sometimes have customer names that start with a zero eg, "0ALPHA" and because of this 0 it doesn't recognize that it should match with "ALPHA". The similarity column is set at zero for this problem so it doesn't match with any names. I am a bit confused because Fuzzy Lookup can match names that have way less similiarities than this.

Do you know why it doesn't work on names with a 0 at the beginning and how to avoid this problem?

PS: I put the threshold at 85%

Many thanks

Hi RSRSRS,

If you replaces all those zeros with the capital letter "O", would this correct your fuzzy problem?

In my reading of how Fuzzy works, it converts the letter group sounds to numbers and then matches the number values to each other. I'd bet Fuzzy doesn't know how to sound a word that starts with a number..

Hey,

I didn't think about Zeros in the middle of words like bad typist used to do. Bob would be spelled B0b because type couldn't tell a zero from an O. I also know that lower case "L" would be used instead of a ONE (1) as typist were being cute. To further figure out why some still don't work, I need to see a better list and see the ones that don't convert. Could you supply a sample workbook?

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi RSRSRS,

Look at Helper2 on sheet1. Try to use it instead of what you had and tell me if that works.

ExcelFuzzy remove leading zero.xlsx