Value with Corresponding Date if Falls Within Range of Dates

Try this formula...
=VLOOKUP(B4,$A$4:$D$118,4,1)

The "1" means an approximate amount (but not over), so your table has to be sorted by date ascendingly.

Hope that helps,
Dennis