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 '18 at 0:29

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, privacy policy and cookie policy

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