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, and UNIQUE by adding bulk fuzzy matching and bulk fuzzy lookup/search capabilities to its own 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 hover your mouse over the "Tutorial" menu above and click any of the submenus to start learning.