How Flookup Works
In this tutorial, we will look at a few examples showing how to use Flookup to clean your datasets, right from your Google Sheets spreadsheet. These topics explore the standard functions of Flookup, upon which all the other functions either depend or expand.
Flookup introduces significant functional upgrades of popular Google Sheets functions like VLOOKUP, HLOOKUP, UNIQUE, SUMIF and AVERAGEIF by adding bulk fuzzy matching and bulk fuzzy lookup capabilities to its own variations of these functions.
About the Flookup Algorithm
We use a two-staged algorithm to power the primary functions of Flookup. First, we break the text into tokens to calculate the percentage similarity between strings, then we refine that result to improve accuracy and overall consistency.
For sound similarity, we use a modified version of the Soundex algorithm. Soundex is a phonetic algorithm for indexing names by sound (as pronounced in English). It encodes different strings to the same representation in order to facilitate matching, despite differences in spelling.
These two algorithms combine to form the core of Flookup and to make it a useful asset in your software stack. Use Flookup to lookup, compare and merge lists of company names, people names, addresses, website URLs etc.
Please click any of the sub-pages above to start learning.