i want to return some valuesStac

Ms Excel :If the name matches and if the input date falls in between two columns of another sheet , i want to return some values
Sheet1 : Salary Average CalculationDateEmployee Name1Employee Name2Employee Name3Employee Name4Emp
admin5小时前
00