Hello,

Attached is an example for reference:

ChangingReference.xlsx


I have a spreadsheet that has a worksheet with a formula that refers to another worksheet through index/match. Currently, if you type in the number of miles and level (both made up things), the cost will be calculated based on the cost per mile in the other worksheet. However, if you change the values in 'Cost per Mile', it changes all of the calculations that already exist.

Is there a way to have the original calculations remain the same when the cost per mile is changed? And have the cost per mile change only affect the calculations AFTER the cost per mile is changed?


Thanks!