To keep track of frequent price changes with several products I have
LIST1 with 3 fields:
'ProductID’, 'DateOfChange’, 'NewPrice'.
Furthermore, LIST2 stores all orders with also 3 fields: 'ProductID',
'OrderDate’, 'QuantitySold’.
Here I need a 4th field, ‘TurnOver', calculated as:[LIST1!'NewPrice']
*[LIST2!'QuantitySold'].
But which formula can find the applicable ‘NewPrice’ valid at
‘OrderDate’ ?

Any assistance is highly appreciated, thank you in advance.

Kind regards,

H.G. Lamy