Thought i would share this link. It gives the code for a fuzzy match version of Excel's vlookup function. I've used it for a couple of years actually, and it works quite well. Extremely useful when trying to match names, places etc.
http://www.mrexcel.com/forum/excel-questions/195635-fuzzy-matching-new-version-plus-explanation.html#post955137 Avinash -- Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org --- You received this message because you are subscribed to the Google Groups "datameet" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
