Recreate daily transaction using daily pricing table

Hi

I need to recalculate daily transactions using a daily pricing table.

For some days the daily price covers more than one day and I get an error in my vlookup if a price does not exist for the exact day of the transaction.

What I want to do is have my vlookup use the daily price valid for the day of the transaction.

e.g Daily price for 7/1/2014 of 1.11 applies for 12/1/2014 and 13/1/2014.

See attached sample file.

Regards

Apologies file not attached. i can't seem to attach the file to the post