Add-ons
Check out the store for many more
Add-on

Flookup


(17)
offered by getflookup.com
1,362 users

Overview

Flookup adds functions to Google Sheets for comparing strings and searching datasets based on percentage or sound similarity.
The basic functions are the eponymous FLOOKUP, HFLOOKUP, SOUNDMATCH, FUZZYMATCH and LATINIZE. These functions upgrade your spreadsheet in the following ways:

1. FLOOKUP finds strings in vertically structured data, based on percentage similarity. Matches, for each lookup value, are listed in order of descending percentage similarity.
2. HFLOOKUP finds strings in horizontally structured data, based on percentage similarity. Matches, for each lookup value, are listed in order of descending percentage similarity.
3. SOUNDMATCH finds strings based on sound (as pronounced in English) in vertically structured data. Matches, for each lookup value, are listed in alphabetical order (A-Z).
4. FUZZYMATCH calculates the percentage similarity between two strings.
5. LATINIZE removes diacritical marks from any string. This is especially useful if applied before using any of the functions mentioned above.

ADDITIONAL FEATURES:
1. Highlight cells with duplicate values based on percentage or sound similarity.
2. Delete rows with duplicate values based on percentage or sound similarity.

Flookup eliminates the need to:
1. Sort data sets.
2. Change the letter case of the text.
3. Clean up any extra spaces.
4. Remove punctuation marks.

WEBSITE: https://www.getflookup.com
DONATE: https://www.getflookup.com/donate

Details

Version: 91
Updated: June 14, 2019
Language: English