Andrew Apell
•  37,525
Overview
Fuzzy Matching and Lookup Functions for Google Sheets
```Flookup is a suite of functions for data cleaning inside Google Sheets by using advanced fuzzy match and fuzzy lookup techniques. Flookup is a good add-on for handling diverse kinds of datasets, even those that contain text with partial matches, typos or spelling variations.

A Brief Overview of Flookup Functions:
1. FLOOKUP: Merge data or match strings in vertically structured data, based on percentage similarity. Matches for each lookup value are ranked in order of descending percentage similarity.
2. HFLOOKUP: Merge data or match strings in horizontally structured data, based on percentage similarity. Matches for each lookup value are ranked in order of descending percentage similarity.
3. SOUNDMATCH: Match strings based on sound similarity (SOUNDEX) in vertically structured data. Matches for each lookup value are ranked in alphabetical order (A-Z).
4. FUZZYMATCH: Calculate the percentage similarity between two strings. It can also calculate the percentage similarity between concatenated strings.
5. ULIST: Extract unique values from a specified range based on percentage similarity.
6. SUMLOOKUP: Merge or sum data based on corresponding partial matches from a single column.
7. MEANLOOKUP: Calculate the average of data based on corresponding partial matches from a single column.
8. NORMALIZE: Remove diacritical marks or stop words from any string. This is especially useful if applied before using any of the functions mentioned above.

1. Highlight duplicates based on percentage or sound similarity.
2. Remove duplicates 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.

WEBSITE: www.getflookup.com

#FuzzySearch #FuzzyMatch #Dedupe #MergeData #DataCleaning```
Reviews
Language:
Sort by:
A User of Flookup
May 29, 2020
Fantastic app , fantastic customer service should you have a problem. This app literally saves our business hours of work per week. Never usually leave reviews but this app , big thumbs up
Yes
No
A User of Flookup
May 13, 2020
This is an excellent add-on, does exactly what it says and what you need it to do. It even automatically includes a column that shows the percent match that is provided which is immensely helpful for focusing on the most important results in a pinch. I would highly recommend this for anyone who spends any time managing data, it has worked flawlessly for my needs. The developer is also extremely helpful and responsive. He even extended the courtesy of personally assisting me with a task I needed to complete.
Yes
No
A User of Flookup
May 13, 2020
Says it is not verified when signing in with Google
Yes
No
A user of Flookup
May 14, 2020
Check our FAQs for help with this
A User of Flookup
April 29, 2020
Looks like a great tool, sadly after installing it's impossible to use because google has disabled it for security reasons (can't 'sign on').
Yes
No
A user of Flookup
May 2, 2020
I apologise for the issue you experienced with installing Flookup but this particular issue is hard to pin down. It occurs randomly and well outside the control of any developer. One possible solution is that you try installing and activating Flookup in incognito mode. Please give it a try and let us know how it went.
A User of Flookup
April 9, 2020
As you can see from the other reviews, this program works for some people and doesn't work for others, kind of like how everyone else can log in to the Zoom meeting except for Carl. But Carl is also the same guy that regularly accidentally "replies all" to company wide emails and last year managed to crash our internal servers despite working in public relations. Yes, if you are log in to more than one Google account Flookup doesn't like it. Yes, if you share your sheet with someone and you don't have an enterprise plan it will not work (though it does appear if the other users only have "view" access Flookup doesn't mind.) But these are necessary security steps so one user can't share this freakin awesome program with other people. Plus you'll get a support response within hours for any issues you have. But first read the really complete FAQ and doc files on the website. This app works greatâ€”quick and easy to use. Nice work.
Yes
No
A User of Flookup
April 2, 2020
Works as expected and does a great job (using it for similarity matching between text fields) -- can save you a lot of time and hassle. Had a little difficulty with the installation but got very fast and excellent support.
Yes
No
A User of Flookup
April 2, 2020
Didn't work. Tool complained about not having a subscription. Entered paypal details twice (once using an account, second just via credit card). A waste of ~1 hour. Was really hoping this would be faster than implementing my own solution using levenshtein distance, but guess I'll have to do it myself.
Yes
No
A user of Flookup
May 5, 2020
It appears you registered a wrong "Subscriber email" account. Correcting this will fix the issue.
A User of Flookup
April 1, 2020
Very helpful! Used it on a list of 1000+ names spread across multiple files for a project in Ethiopia. Since there was no unique ID, the name was the only identifier which was spelt differently in different files. This add-on was faster than the one in excel returning better matches. Quick tip: use different percentages and ranks to make your process even quicker. Cheers!
Yes
No
A User of Flookup
March 12, 2020
Yes
No
A user of Flookup
March 20, 2020
This problem is addresses in their FAQ section on their website. Problem occurs if you are logged into more than 1 google account at a time. I logged out of a second account and this message went away
A User of Flookup
March 5, 2020
Does not offer what is advertised. Stay far away from this.
Yes
No
A user of Flookup
May 2, 2020
Sorry but you have to subscribe for Flookup to work.
1-10 of 22