Vlookup - approximate match = TRUE and Fuzzy lookup
Vlookup approximate match = TRUE almost never works because it's not what it sounds like.
For matching a dataset with another, there is an add-in called Fuzzy lookup.
http://www.microsoft.com/en-us/download/details.aspx?id=15011
It is very simple to use and allows us to set threshold to find similarity. It gives required results with 90 to 95 percent accuracy.
I set my thresholds at 0.8 most of the time, anything below, it gives data that I don't want and above that, it misses some vital information. Finding the sweet spot also depends on the data being compared and acceptable level of accuracy.
For matching a dataset with another, there is an add-in called Fuzzy lookup.
http://www.microsoft.com/en-us/download/details.aspx?id=15011
It is very simple to use and allows us to set threshold to find similarity. It gives required results with 90 to 95 percent accuracy.
I set my thresholds at 0.8 most of the time, anything below, it gives data that I don't want and above that, it misses some vital information. Finding the sweet spot also depends on the data being compared and acceptable level of accuracy.
Comments