I can use VLOOKUP to find something from a calculated field, but the GOOGLEFINANCE function just gets stuck loading forever:

Sample spreadsheet

In this example, GOOGLEFINANCE is used to find the stock name, the "Tag" column is a VLOOKUP

Here's the config for the calculated fields:

Calculated field config

Sample spreadsheet:


I know I could move the GOOGLEFINANCE call out of the calculated field, but I'm interested to know why it doesn't work in the calc field.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.