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?