Posted by Joel Horowitz on December 04, 2001 1:22 PM
I am currently trying to match two databases of company names, but the problem is that their names do not always appear exactly the same.
Who has a suggestion on how to tackle the problem of 'approximate vlookup'? I mean looking names in a database when they're not written exactly the same way. I'm aware of the TRUE attribute for vlookup, but that doesn't really solve the problem.
Let me define properly what I would like to do: I want to give as input a name + a list, and get as output the first entry in the list that contains that name, or alternatively, the entry that has the biggest chunk of letter in common (or any other criteria that would maximize the chance that the match is the correct one)