Need help in Vlookup in Excel

#1
I have an excel file in which I have 2 columns Index and Date. In the second sheet I have 4 columns Index,name,startdate and enddate. I want to lookup the name in the on the basis of index if the date in table1 is between the start and enddate of table2.

In the sheet 1 I have a tab_no and Survey Date. In the sheet 2 I want the names based on the tab_no and the survey date should be between the start and end date.

Refer this link : https://drive.google.com/file/d/0B2wvr5gjqmj3bUwxVU1hV29SN2c/view
 
Last edited: