Changing LOOKUP table prices changes previous sales too!

Originally Posted by FDibbins

to add in to K M's 2nd suggestion, you could add a date to all of you'r prices in a 2nd column, and then use that to help seperate btw the old and updated price lists. add a helper column and concaternate (using =(date-cell&date-cell), and then do the vlookup based on a concatenate on your data sheet into the helper column.

if this is a little confusing to you, upload a sample workbook, and i will help you get started

This looks like REAL WORK, but it's probably in my best interest to LEARN this and I think this will save me problems in the long run.

Yes, it is a little confusing, but I will work on it myself 1st. I don't want the reputation of someone who just wants things done FOR ME. Learning Excel is part of the goal.

IF I can't get it with a reasonable amount of effort on my part, I will take you up on your very generous offer!

Cane

---------- Post added at 09:31 AM ---------- Previous post was at 09:23 AM ----------

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.