NORMALIZE: Remove diacritical marks from strings.
FUZZYMATCH: Calculate the percentage similarity between strings.
FLOOKUP: Lookup and merge data in vertically structured data, based on percentage similarity.
HFLOOKUP: Lookup and merge data in horizontally structured data, based on percentage similarity.
ULIST: Extract unique values from a specified range based on percentage similarity.
SOUNDMATCH: Match strings based on sound similarity (SOUNDEX) in vertically structured data.
How to Activate Your Flookup Plan
Submit your email through the secure form located in your spreadsheet menu at Add-ons > Flookup > Manage subscription > Premium plan. You will receive a confirmation email from PayPal upon completion.
This should be the email address that you use to access Google Sheets.
Please be mindful of the letter case you use. Email addresses are case sensitive.
Update your subscription status by clicking "Refresh" via Add-ons > Flookup > About Flookup.
You can subscribe with a PayPal account, a debit card or credit card.
You can cancel your subscription any time and retain your premium plan until it expires.
Clicking "Refresh" fetches your current trial or subscription status.
Troubleshooting Your Subscription
What the Status Messages Mean
Your subscription is active: Your subscription is functioning properly.
Your subscription is inactive: Your subscription has expired.
Please subscribe to upgrade Flookup: You either registered the wrong email address or you have not yet subscribed. Please contact us for assistance with the former.
Your free trial will expire in x hours: Your trial period is still active for the stated number of hours.
Steps to Try:
Make sure that you are the owner of the spreadsheet you installed Flookup in. To correct this, simply reinstall Flookup in a spreadsheet you own.
If you are logged into 2 different accounts at the same time, Flookup might fail to authenticate correctly. Please ensure that your "Subscriber email" account is the default account or, if possible, sign out of the secondary account.
Log into the right account (best in incognito mode), then reinstall Flookup via the spreadsheet menu. You do not need to re-subscribe after doing this.
Don't forget to click the "Refresh" button after trying each of these steps.
How to Cancel Your Subscription
If You Have a PayPal Account
Head to Add-ons > Flookup > Manage subscription > Premium plan.
Click "Unsubscribe" in the resulting window.
Follow the next steps from your PayPal account.
If You Do Not Have a PayPal Account
Compose a new message from our Support page.
Under Subject, select "Unsubscribe".
In the next section, type or paste your Profile ID. Do not include anything else.
You can get this from the confirmation email PayPal sent when you subscribed.
Click the "Submit" button.
All payments are securely processed through PayPal. The details of any payment we receive e.g. the payment amount, the subscriber email address and name you registered with PayPal, are kept private, confidential and secure. We cannot and do not see your credit card information or any other sensitive financial data.