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 chapters 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 approximate string matching and bulk processing capabilities to its own variations of these functions.

About the Flookup Algorithm

Flookup currently uses a modified version of the Cosine Similarity algorithm for calculating the percentage similarity between any two strings. This algorithm works by calculating the dot product of the vector representation of any two strings and Flookup uses this principle to return a percentage similarity that closely matches the user's prior expectations.

For sound similarity, we use a modified version of the refined Soundex algorithm. Soundex is a phonetic algorithm for indexing names by sound (as pronounced in English). It encodes 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 formidable asset in your software stack.

Please click any of the links below and start learning: