Get Price from price list changes file on the basis of order date

[exeluser1]

Hi!

I have a Table 1 with price list changes for a commodity:

Date of change	Commodity ID	New Price
2017 Jan 01	132	$10.5
2017 Jan 01	150	$20
2017 March 04	132	$12
2017 July 10	132	$15
2017 Aug 01	150	$25

<tbody>
</tbody>

And I have a Table 2 with orders (but w/o prices), and I need to get correct price from Table 1 on the basis of order date so it should look like (marked red):

Order Date	Commodity ID	Quantity	Unit price
2017 Jan 03	132	10	$10.5
2017 Jan 30	132	10	$10.5
2017 Mar 05	150	10	$20
2017 Aug 15	132	10	$15
2017 Aug 20	150	10	$25

<tbody>
</tbody>

How can I do that using Excel Formulas?

Thanks!

 

[exeluser1]

More explanation:
Order date (Table 2) should be compared to price change dates, and the closest from the past (Table 1) should be taken (or the same date if order date equals date of change).