Changing LOOKUP table prices changes previous sales too!

- You would set up a Table to indicate the correct price for a given day
- What you do is setup a lookup formula probably VLOOKUP
- Using the DATE, Excel would look up the correct PRICE.

If you need any more help, you may want to load sample file so I could help

---------- Post added at 01:22 PM ---------- Previous post was at 11:05 AM ----------

The formula would like this:

=Vlookup(A1,Price_Array, 2, False)

where: A1= lookup_date {change accordingly}

Price_Array = Array of Dates and Prices {I would define a named range}

2 = col_index, {In this case, values are the 2nd column}

False = {Dates and prices do not have to be in order}