fuzzylookup

Hi, I have a function that performs a "fuzzy" lookup/find against a set of data to find matching values. For example, for each cell in Field 1, the value in that cell is looked up against the entire range of data in Field 2, and where there is a "Fuzzy" Find/match, that value is populated on...

Greetings to all from a new user! This is a fantastic forum and site, and I'd like to thank the community and Mr. Excel in advance! OK, here's my issue. I have 2 lists to match: I am trying to match 2 columns of company names, one current customers (15,000), and one a list of industry leaders...

Hi! I'm a noob when it comes to using VB with Excel and everything I do I've ripped off of other people. :) That being said I was trying to implement the FuzzyVlookup that I've seen posts about on here into a workbook. When I added it worked just wonderfully but it ended up for whatever reason...

So I'm using FuzzyHLookup (and thanks a lot to all who contributed to the FuzzyLookups - they're awesome) and instead of returning the value contained in the closest matched field it is returning a number corresponding to the position of that field in the row. My formula is...