So I've set up automatic MySQL sheet that gets the data from it every day at 8pm.

I've set up everything with vlookup, and tried indirect. But I can't figure out how to make sure the values don't change when the data from database updates.

Does anyone know how to make it so that Vlookup or indirect doesn't change the value when database updates the numbers?

  • What do you me mean by " automatic MySQL sheet"?
    – Rubén
    Dec 25, 2018 at 0:29

1 Answer 1


There is no way to avoid that a spreadsheet function like VLOOKUP and INDIRECT don't change. The alternative is to replace the cell formula by it's result.

You could do this manually by using copy then paste only values, by using Google Apps Script of the Sheets REST API.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.