Lookup beween 2 dates

[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