Help & Support
Send Feedback
Flookup
Flookup adds functions to Google Sheets for comparing strings and searching tables based on percentage or sound similarity.
getflookup.com
2,294 users
Works with
Install
Overview
The add-on functions are the eponymous FLOOKUP, FUZZYMATCH, XFLOOKUP, ZFLOOKUP and RD.

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. ZFLOOKUP finds strings in horizontally structured data, based on percentage similarity. Matches, for each lookup value, are listed in order of descending percentage similarity.
3. XFLOOKUP 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. RD removes diacritical marks from any string. This is especially useful if applied before using any of the functions mentioned above.

Finally, you can also highlight cells or delete rows with duplicate values by accessing the respective functions from the add-on menu.

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

Visit https://www.getflookup.com for more information.
Reviews
A Google User
January 18, 2019
Great time saver for matching names written in different ways.
Submit reply
Cancel
September 18, 2018
Tremendous tool. I have been notoriously avoiding google sheets for any work but flookup makes it not only easier but fun to work. Thanks to the developer and keep them coming. Big thumps Up!
Submit reply
Cancel
1-2 of 2
Additional information
Search
Clear search
Close search
Google apps
Main menu