Help & Support
Send Feedback
Flookup
Fuzzy match strings, and highlight or remove duplicates in Google Sheets, by percentage or sound similarity.
42,282 users
Works with
Install
Overview
Flookup is an advanced tool for fuzzy matching (also called approximate string matching) in Google Sheets. With Flookup, you can easily search for text, and highlight or delete duplicate values, regardless of whether they are exact matches, partial 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. SUMLOOKUP: Merges or sums corresponding partial matches from a single column.
7. MEANLOOKUP: Calculates the average of corresponding partial matches from a single column.
8. NORMALIZE: 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 duplicate values based on percentage or sound similarity.
2. Remove 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.

You can also use Flookup to:
1. Remove diacritical marks.
2. Remove custom stop words.

#SEOtools #Dedupe #GetFlookup

WEBSITE: https://www.getflookup.com
SUPPORT: https://www.getflookup.com/feedback
PRICING: https://www.getflookup.com/pricing
Reviews
A User of Flookup
November 27, 2019
it works
Submit reply
Cancel
A User of Flookup
October 5, 2019
ITS WORK..!!! Real Impressive Tools, And Thanks to the creator for the Help.
Submit reply
Cancel
A User of Flookup
October 2, 2019
It is awesome and very beneficial in finding matches in no time ๐Ÿ‘๐Ÿป๐Ÿ‘๐Ÿป
Submit reply
Cancel
A User of Flookup
September 30, 2019
This didn't work for me at all. Have no idea why, but it didn't even identify exact matches. Also, hugely slowed down my gsheet.
Submit reply
Cancel
A User of Flookup
June 24, 2019
Works perfetly, one of a kind, managed to create auto-translation tool with its help.
Submit reply
Cancel
A user of Flookup
July 1, 2019
Thank you very much for your review and kind words. I'm glad it was helpful to you!
A User of Flookup
January 24, 2019
Great Add-on. It's surprising how it decides to match things sometimes, but it's helped take a project form completely manual to mostly automated. So thank you for your work on this. I've been using it for a few months now and still really like it. The only problem is the ERROR it throws when it's been called too many times. Is there a way to add a pause in there or some kind of setting to control the speed?
Submit reply
Cancel
A user of Flookup
July 4, 2019
Hello. There are a few similar issues we've solved in the past few months but most of them required details we cannot sufficiently discuss here. Please head to www.getflookup.com/feedback and post a detailed bug report there. Thank you
A user of Flookup
July 1, 2019
this error seriously impairs usability of an otherwise cool utility. Please fix! I vote for a global setting to vary the request rate.
A User of Flookup
January 18, 2019
Great time saver for matching names written in different ways.
Submit reply
Cancel
A User of Flookup
January 4, 2019
What a wonderful feature! Many many thanks.
Submit reply
Cancel
A user of Flookup
July 1, 2019
You're welcome and thank you for choosing Flookup!
A User of Flookup
October 18, 2018
does not work as intended whatsoever. only returns exact values
Submit reply
Cancel
A user of Flookup
November 5, 2019
I have trouble getting it to work at all, even for exact matches. Seems like it runs into an issue after the first few rows. In my case it cannot even match a string as simple as "Bill Carter". I do not recommend!
A user of Flookup
May 29, 2019
Please visit www.getflookup.com/tutorial to find out how to effectively use Flookup. I hope that you find gainful information there.
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-10 of 11
Additional information
Search
Clear search
Close search
Google apps
Main menu