Tutorial

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

Flookup works by getting the quotient of the dot product, divided by the magnitude of the vector representation of two strings.

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 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.

Please click any of the sub-pages above to start learning.

Fuzzy lookup Mac #GetFlookup