FLOOKUP FUNCTION DOCUMENTATION

Introduction to Flookup Functions

Flookup functions are accessible through the add-on 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 versatile custom function variant that you can utilise by typing its respective function name directly inside any spreadsheet cell instead of going through the add-on menu. These variants have a maximum runtime of 30 seconds per execution.

For example, you can quickly match and merge data by typing =FLOOKUP() inside an appropriate cell.

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.