Flookup [Fuzzy Lookup] uses the discipline of fuzzy matching to power data cleaning in Google Sheets. Flookup is perfect 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, QLOOKUP and MLOOKUP: Merge data or match text 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 text in horizontally structured data, based on percentage similarity. Matches for each lookup value are ranked in order of descending percentage similarity. 3. SOUNDMATCH: Match text based on sound similarity (REFINED 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 text entries. It can also calculate the percentage similarity between concatenated text entries. 5. ULIST: Extract unique values from a specified range based on percentage similarity. 6. NORMALIZE: Remove diacritical marks, punctuation marks or stop words from any text. This is especially useful if applied before using any of the functions mentioned above. ************************ Additional Functions: 1. Highlight duplicates based on percentage or sound similarity. 2. Remove duplicates based on percentage or sound similarity. ************************ Common Flookup Use-cases: 1. Email Campaigns: Clean your email list by removing duplicates and out-of-use or invalid email addresses. 2. Database Standardisation: Ensure that your records are up-to-date and consistent by comparing and linking data across disparate sources. 3. Database Scrubbing: Fix database errors like spelling mistakes, missing or duplicate entries and formatting differences. 4. Website Redirect Mapping: Reduce the manual work and errors associated with mapping redirects for 404 and site migration cases, thereby improving your overall SEO strategy. 5. Fraud Detection: Discover and remove data that exists in more that one database when it should not, even with "disguised" spelling differences. ************************ [Website] https://www.getflookup.com [Community] https://groups.google.com/g/flookup [Getting Started] https://groups.google.com/g/flookup/c/y6x322xPMi0 Thank you for choosing Flookup!