Help & Support
Send Feedback
Flookup
Flookup compares strings and searches data sets based on percentage or sound similarity.
36,822 users
Works with
Install
Overview
Flookup is the #1 solution for handling fuzzy or approximate matches in Google Sheets. With Flookup, you can easily manage duplicate and unique values regardless of whether they are exact matches or typos.

The core functions of Flookup are:
1. FLOOKUP: It searches for strings in vertically structured data, based on percentage similarity. Matches for each lookup value are returned in order of descending percentage similarity.
2. HFLOOKUP: It searches for strings in horizontally structured data, based on percentage similarity. Matches for each lookup value are returned in order of descending percentage similarity.
3. SOUNDMATCH: It searches for strings based on sound (as pronounced in English) in vertically structured data. Matches for each lookup value are returned in alphabetical order (A-Z).
4. FUZZYMATCH: It calculates the percentage similarity between two strings. It can also calculate the percentage similarity between concatenated strings.
5. ULIST: It returns unique values from a specified range based on percentage similarity.
6. LATINIZE: It removes diacritical marks from any string. This is especially useful if applied before using any of the functions mentioned above.

Additional Features:
1. Highlight selected rows containing duplicate values based on percentage or sound similarity.
2. Delete selected rows containing 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. Remove extra spaces.
4. Remove punctuation marks.
5. Remove diacritical marks.

WEBSITE: https://www.getflookup.com
SUPPORT: https://www.getflookup.com/feedback
Reviews
A User of Flookup
February 24, 2019
I want this to work badly, but it doesn't work.
Submit reply
Cancel
A User of Flookup
January 18, 2019
Great time saver for matching names written in different ways.
Submit reply
Cancel
A user of Flookup
August 13, 2019
Thank you for choosing Flookup!
A User of Flookup
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-3 of 3
Additional information
Search
Clear search
Close search
Google apps
Main menu