=MAX(INDEX((Sheet2!$A$2:$A$10=A2)*(Sheet2!$A$2:$A $10<=B2)*(Sheet2!$B$2:$B$10),0))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"John" wrote in message
...
I have dates in column A & B. They correspond to dates in column A of
sheet2... In column C (of sheet1) I would like to find the max value found
on
Sheet2 in column B corresponding/between the two dates of cloumn A&B on
sheet1. Is that make sense?

Thanks for your cunning thoughts!