Lookup beween 2 dates

F

Frank

To keep track of frequent price changes with several products I
maintain LIST1 with 3 fields: ProductID, DateOfChange, NewPrice.
Running orders are stored in LIST2, with also 3 fields: ProductID,
OrderDate, QuantitySold.
Here I need a 4th field, “TurnOver” = [LIST1!NewPrice] * [LIST2!
QuantitySold]).
How can Ifind the NewPrice valid at OrderDate?
Thank you in advance.

Kind regards,

H.G. Lamy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top