Thursday, August 25, 2011

yogi_Paste Value In A Cell Using Data Validation

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
jkm1317 said:
Is there a way to automatically input a formula for ONE TIME only? I have a sheet where I am using vlookup to calculate a total. (Price*quantity = total). Well as time (years) goes on this price has changed (e.g. inflation). So my issue is that when i change the price all my old calculations would change as well. i would like gdocs to lookup the answer and hold it.
I hope you can help!
Thanks!
------------------------------------------------