Hi,

Try this ARRAY formula which would go on Sheet1

=VLOOKUP(MAX(IF(Sheet2!A1:A27=A1,IF(Sheet2!A1:A27 <=A2,Sheet2!A1:A27))),Sheet2!A1:B27,2,FALSE)

This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"LaDdIe" wrote:

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.