Changing LOOKUP table prices changes previous sales too!

Ah...yes...my mistake...sorry...wrapping my mind around the WORKBOOK, WORKSHEET, SHEET, etc., terminology has been harder for me than some of the functions. Several weeks ago all I knew was SPREADSHEET.

---------- Post added at 09:48 AM ---------- Previous post was at 09:40 AM ----------

Originally Posted by K m

I thought of another approach that you may consider:

- You might include a Lookup table with DATES and PRICE
- You would have to provide a column or range to indicate the date.
- Write a simple Lookup formula to lookup the price based on the date you supplied
- That way the approaches above would not be necessary and all of the formulas could be the same

This approach would be more difficult to set up but would be easier to follow once it is set up

Kirk

This sounds really good...I think I can do it...

Just so I am clear...I have all the formulas copied presently to row 5000. Today I would redo the formulas and recopy them (only from today's 1st row) to row 5000. WHEN I have another price change, I reset the formula accordingly and recopy to row 5000 from THAT day's 1st row.

Am I close???