Vlookup Returning Values based on Date Range

[kgibson20]

I have a spreadsheet where I need to return a value of 1 if the number on one spreadsheet matches a number on another spreadsheet and the date next to it falls into the range I've specified at the top of the first sheet if not it will return a 0.I've attached a file that simplifies it into one sheet. I need to return a 1 in column D if the matching number from column E has a date next to it within the range specified at the top. I was using a vlookup which works fine, but I would like to be able to change the data (1,0) based on the date range. The formula I'm using is VLOOKUP(D4,$E$4:$F$15,2,FALSE). Any help would be appreciated