Retrieve data from a cell based on date criteria in another

[ajob]

In the attached spreadsheet I need a formula to extract the value from column C that matches the date in Column E where the date in column E is equal to or falls between the dates in Columns A and B.

Apologies file now attached.

[Tony Valko]

Don't see an attached file?

[Tony Valko]

One way...

Data Range

	A	B	C	D	E	F
1	Data
2	Start Date	End Date	Value	-----	Date lookup	Value
3	10/1/2014	10/1/2014	1.555		10/1/2014	1.555
4	10/2/2014	10/2/2014	1.558		10/2/2014	1.558
5	10/3/2014	10/3/2014	1.6		10/3/2014	1.6
6	10/4/2014	10/7/2014	1.665		10/6/2014	1.665
7	10/8/2014	10/11/2014	1.753		10/9/2014	1.753

This array formula** entered in F3 and copied down:

=INDEX(C$3:C$7,MATCH(1,IF(E3>=A$3:A$7,IF(E3<=B$3:B$7,1)),0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[ajob]

Thanks that solved my issue. Appreciate the prompt reply.

[Tony Valko]

You're welcome. Thanks for the feedback!