Need help in Vlookup in Excel

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 :
Last edited: