return a value in a range if cell has date that fall between two dates

[preciouslife73]

I want to be able to return a value within a range where the vlookup works if a cell has a date that fall between two dates. for instance:
Column A has start date of year( jan 1st 2001) Column B has end date of the yar (dec 31, 2001) each row are the same except it goes down to year 2013. Now the Column C has the value that I want to return from the specified row, if a date in cell D1 contains the date that fall between these two dates in column a and b. I have found alot of solutions but those solutions only tells me if it is true or false or if you type text value in the "". Any assistance is greatly appreciated.

[FDibbins]

Its a lot easier to find solutions if you have some sampel data to play with (well, for me it is, anyway)

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that

[preciouslife73]

Example.xlsx

see attached. I hope I was able to attach a sheet.

[Palmetto]

As long as your dates are sorted in ascending order, as you now have it, this should work:

=INDEX($D$2:$D$14,MATCH(G14,$B$2:$B$14,1))

[preciouslife73]

Thank you!This really works! Awesome!