Excel 2007 : Look up dates & return value

Table 1 has a list of stock prices for specific dates.

Table 2 has a list of dates and I'm trying to automatically pull in the stock prices from table 1.

I'm trying to write a formula that compares the date in table 2 to the date in table 1 and then returns the correct stock price. The catch is that they will not be an exact match. The stock price in table 1 remains current until a new price has been established in table 1. So, in my attached example, I need the formula to know that the date in table 2 is after the effective date in table 1 but before the next effective date in table 1.

This is very difficult for me to explain properly. Does this make sense?

Thanks,
Steve