If a date in a cell is between two dates in a table retrieve the right value/text

[nunomd]

Hi everyone,
I hope you could help me out with this question:
I would like to have the formula to insert in the cell F2, F3 and F4. If the date in cell E2 is between dates in A and B column should retrieve the right value/text in column C (to cell F2). The same for dates in cell E3, E4 and E5.
Thank you so much.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]From[/TD]
[TD]To[/TD]
[TD]PW[/TD]
[TD][/TD]
[TD]Dates[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][TABLE="width: 187"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]16/01/2015[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 187"]
<tbody>[TR]
[TD]15/05/2015
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]PW1[/TD]
[TD][/TD]
[TD]17/01/2015[/TD]
[TD]PW1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 187"]
<tbody>[TR]
[TD]16/05/2015
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 187"]
<tbody>[TR]
[TD]31/05/2015
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]PW2[/TD]
[TD][/TD]
[TD]18/01/2015[/TD]
[TD]PW1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]19/01/2015[/TD]
[TD]PW1[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]19/05/2015[/TD]
[TD]PW2[/TD]
[/TR]
</tbody>[/TABLE]

 

[AlanY]

in F2 and copy down

=IF(AND(G2>=A2,G2<=D2),E2,"")

 

[nunomd]

Didn´t work. Maybe I didn´t explained myself right. The text in red is what I want to achieve with the formula. The dates in column E must "read" the table between A2 to B3 (and if they fill the condition retrieve text in column and not only by line 2 as you suggested. Thank you.

 

[AlanY]

may be this

=IF(AND(G2>=$A$2,G2<=$D$2),$E$2,IF(AND(G2>=$A$3,G2<=$D$3),$E$3,""))