If date < = list range, return value

[Weeble]

I have a table with different dates in column A
[TABLE="width: 500"]
<tbody>[TR]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]2017-01-15[/TD]
[TD]Apples[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2017-02-15[/TD]
[TD]Apples[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I also have a list with different prices depending on the time of date.

[TABLE="width: 500"]
<tbody>[TR]
[TD]2017-01-01[/TD]
[TD]25,5 $[/TD]
[/TR]
[TR]
[TD]2017-02-01[/TD]
[TD]27,6 $[/TD]
[/TR]
[TR]
[TD]2018-01-01[/TD]
[TD]32,4 $[/TD]
[/TR]
</tbody>[/TABLE]

I want to make a formula in D column that goes similiar. " IF col A =< Date from my list ; C * value from list )

So if the apples have been sold 2017-01-15 or earlier than that the calculated price should be 25,5.
But if it's been sold between 2017-02-01 and less than 2018-01-01 the price should be 27,6.

How would I do this an easy way?

 

[Special-K99]

=INDEX(E1:E3,MATCH(A1,D1:D3,1),1)

where A1 is your apple date
D1:D3 are your price table dates
E1:E3 are your prices

 

[Weeble]

it's so simple that I even forgot that you can put a 1 instead of 0.
Thank you