FLOOKUP FUNCTION DOCUMENTATION

Introduction to Flookup Functions

Flookup's powerful data cleaning functions are easily accessible through the add-on menu in Google Sheets. Each function has a maximum runtime of 6 minutes per execution, after which it times out automatically and displays results for the processed data up to that point.

You can re-run the function without restrictions for further adjustments.


For even greater flexibility, Flookup provides custom function variants. These can be typed directly into any spreadsheet cell using their respective names.

Custom functions, such as FLOOKUP, are perfect for quickly matching and merging data, and the have a maximum runtime of 30 seconds per execution.

Clickable image leading to our guide on fuzzy matching algorithms.
Clickable image leading to our guide on automating Flookup functions by running them on a schedule.
Clickable image leading to our guide on preprocessing data by text similarity for efficient data cleaning.
Clickable image leading to our guide on matching and merging data by text similarity for effective data cleaning.
Clickable image leading to our guide on removing duplicates by text similarity for accurate data cleaning.
Clickable image leading to our guide on highlighting duplicates by text similarity for precise data cleaning.