Excel 2007 : Look up dates & return value

[stevetothink]

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

[ConneXionLost]

How about:

=VLOOKUP(B17,$B$6:$C$12,2,TRUE)

Note that Table 1 must be sorted by the effective date.

Cheers,