Changing LOOKUP table prices changes previous sales too!

Originally Posted by K m

There are a few ways to do this.

- One way is to change the cell references to a cell with the new price. This could easily be done with FIND/REPLACE
The FIND/REPLACE would be for new prices only. Leave the other formulas alone

- A second way is to "lock in" the previous prices. Copy a range of cells and PASTE/SPECIAL/VALUES.
Those cells would no longer have formulas but have "fixed" numbers

- The last approach is to make a duplicate copy of the worksheet.
This new worksheet could have different formulas to reflect the new prices.

No. 1 - I should have thought of that one...it would have done the trick but your 2nd suggestion looks like the better long term one.

No. 2 - I didn't know that could be done...although I could have researched that before I asked. This is a good suggestion AND something I can use to solve another unrelated problem I am having.

No. 3 - If I understand that one correctly I would be creating new spreadsheets each time I have price changes.

Thank you very, very much for your time and attention, K m - this will do the trick for me.

Cane