Using Free Fuzzy Match

This add-on adds the function =FUZZY_LOOKUP() to your spreadsheet. The function uses something called Levenshtein Distance to identify fuzzy matches based on a criteria you specify. Beat typos and non-standardization into submission!

Note that this function will not identify exact matches. This way, you can search the same column that the searchTerm comes from and only find typos that are similar.

How to use:

=FUZZY_LOOKUP(searchTerm, searchRange, outputColumn, threshold)

searchTerm: The single value you want to find fuzzy matches for

searchRange: The range that you want to search for a fuzzy match to the searchTerm. Only the first column will be searched, similar to VLOOKUP

outputColumn: The number of the column from the search range that you want data from. After identifying a fuzzy match in the first column, the cell from this number column will be returned

threshold: Determines how close a match should be to get flagged from 0 to 1. Recommended values are roughly .6 - .8 for names and other short text