Lookup date with largest value between 2 dates

[wallstudio]

I have worksheet with 2 columns. Column A are date in ascending order. Column B are numbers. C1 and C2 are dates for me to input. C3 is the result.

I need to find the largest number in column B which is between dates of C1 and C2 and return the corresponding date as result.

Have been thinking for a while and can't figure it out. Can anyone help? Thanks a lot.

 

[wallstudio]

Great! This is what I want. As long as it finds the first largest number in between, it all set. Thanks a lot.

 

[Peter_SSs]

Great! This is what I want. As long as it finds the first largest number in between, it all set. Thanks a lot.

So in my example, were you looking for the date 6/04/2011 or just the value 69?

 

[wallstudio]

I'm looking for the date 6/04/2011. I have combined the D1 formula into C3. It works great. Thanks a lot.