Changing LOOKUP table prices changes previous sales too!

Originally Posted by K m

This is what I had in mind

=IF(C2="",0,INDEX(ProductLookup!$B$3:$G$11,MATCH(C2,ProductLookup!$A$3:$A$11),MATCH(B2,ProductLookup!$B$1:$G$1)))

The First MATCH uses the SKU to find the proper row in the ProductLookup
The Second MATCH looks to see at the DATE and matches the proper column in the ProductLookup. Therefore if there has been a price increase before the ship date, the new price is reflected.

I am sending you your file back with the equations


I hope I explained it well enough

You're too kind, K m - thank you. I really don't expect people who help me to "do it for me", but I realize it could take a lot more of your effort and time to teach me.

And, I absolutely had the wrong thing in mind. Had you helped me do what I was trying to do, you'd have helped me make a mess.

I understand this well enough to use it now, and probably to make future use of it. This is going to be a heck of a tool for me.

I just can't thank you enough...

Best regards,
Cane

---------- Post added at 07:07 AM ---------- Previous post was at 06:55 AM ----------

K m -

Cane Rivero here - again.

I'm interested in the idea of "lock in" previous prices.

As I move my cursor around the spreadsheet, sometimes unintended things happen. 1st, I have to learn how to move the cursor around without having that happen, and I will. But...

...can you suggest a sort of "best practice" ?

"Lock in" say, at the end of each week, would (I think) do it...but since I know so little maybe you could tell me if there is a more appropriate way of keeping things from changing?

Regards,
Cane