Embedded Files
"Why is everyone trying to make me pay for this" - Me, 2024
Send me a digital coffee :)
Send me a digital coffee :)
If you like the add-on, consider sending me a buck or two!
Using Free Fuzzy Match
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 PURPOSEFULLY SKIP EXACT MATCHES because you can find these with normal VLOOKUP. This way you can search your data specifically for fuzzy matches such as typos or near-duplicate entries.
How to use:
=FUZZY_LOOKUP(searchTerm, searchRange, outputColumn, threshold)
searchTerm: The string that you want to use to try to find a fuzzy match.
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.
threshold: Determines how close another string must be to be counted as a match. This has a range of (0, 1) and recommended values are roughly 0.6 - 0.8 for names and other short text fields.
0 = Any text will match
1 = Only exact text will match
outputColumn (optional): 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.
Page updated
Report abuse