Return All occurrences based on 2 criteria

Hi everyone!
I need to return all the occurrences of a list, based on 2 criteria. So far I have it working well with just the one criteria, but I'm struggling with the 2nd "if" statement.

Picture1.png

COL A COL B COL D COL E COL F
R1-DATE VALUE NUMBER DATE IN DATE OUT
R2-24/03/2015 769 17/07/2014 24/02/2015
R3- 769 1080 02/02/2015
R4- 1080 765 08/05/2015 25/09/2015
R5- 0


I have the formula is COL B, ROW 3.
=INDEX(SHEET2!$D:$D,SMALL(IF(SHEET2!$E:$E<=$A$2,ROW(SHEET2!$D:$D)),ROW()-2),1)

This is returning 769, next occurrence, 1080. However, I want it to only return the numbers in Col D if they have NO date in Col F (as well as it being less than or equal to the date in A1) So it needs to only return "1080"

I hope someone can help

Thanks in advance!
Casey