Lookup beween 2 dates
 

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