FLOOKUP DATA WRANGLER DOCUMENTATION

Introduction to Flookup Functions

Flookup functions are accessible through the spreadsheet menu. They have a maximum runtime of 6 minutes per function execution, after which they automatically timeout.

Results from the data that has been processed up to that point are then displayed but you retain the option of running the function again without any restrictions.

Each function has a less powerful but versatile custom function variant that you can utilise by typing the respective function names directly inside any spreadsheet cell instead of going through the custom menu.

For example, you can match and merge data by typing =FLOOKUP(A2, B1:B500, 2, 1) inside an appropriate cell.

Clickable image leading to our guide on using Flookup custom functions.
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.