FAQ

Frequently Asked Questions

Does Flookup transmit spreadsheet data to any third party?

  • No, Flookup does not transmit spreadsheet data to anyone.

Does Flookup store the spreadsheet data it processes?

  • No, Flookup does not store any spreadsheet data it processes; we do not have any need to do so.

Do Flookup developers view user data?

  • No, it is our policy not track users or usage patterns outside the script execution data (successes and failures) that Google provides by default.

I subscribed but I still don't have the Premium Plan features

  • Give it a few minutes. When you subscribe, your premium experience is unlocked immediately. However, in some rare cases, there might be a delay because of server synchronisation but this does not take more than 20 minutes.
  • Review your subscription status. You can find out more by clicking here.
  • Make that sure you entered the correct email address under Subscriber Email and that you clicked Sync Flookup.

Is Flookup available as an API?

  • No, not yet.

Is Flookup free?

  • Yes, Flookup has a free option which is available without subscription.

COMMON SPREADSHEET ERRORS

Internal error executing the custom function.

  • This error means that the function timed out because only allows Google 30 seconds of execution for custom functions . Reducing the table sizes usually resolves the issue.

Service invoked too many times in a short time: exec qps. Try Utilities.sleep(1000) between calls.

  • Try entering a range as the parameter, instead of a single cell, if the function allows it. Please visit the tutorial to find out how.

#NAME

  • Ensure that you have typed the correct function name and then try reinstalling Flookup, reloading the spreadsheet or running any of the Flookup functions in the add-on menu.

Loading...

  • Try reloading the spreadsheet or reducing the number of cells that are concurrently performing calculations.

#NullResult

  • This means that you either reached the maximum number of rows that the free version of Flookup can process at a time or no match was found for the arguments you entered.