Hello

Criteria dates;
(Sheet 1) A1 = 01/01/2009, A2 = 31/01/2009
(Sheet 2) A1 to A27 list of dates 01/01/2009 to 27/01/2009

I need a formula that will find cell with the highest date in the range
between the criteria dates, and the return the value of the adjacent cell
(Sheet 2) Col B.

Thank you.