Lookup between dates

[macangc]

Hi

I have a spreadsheet im trying to complete which if done manually will take forever but i cant work out how to automate.

In one sheet i have information as per the below

Date Employee Name Holiday taken
02/06/2018 Joe bloggs
03/06/2018 Joe bloggs
06/06/2018 Joe bloggs
02/06/2018 John Smith
03/06/2018 John Smith
06/06/2018 John Smith


In another sheet

I have the below

Name Start Date End Date Working Days taken
Joe Bloggs 02/06/2018 02/06/2018 1
Joe Bloggs 03/06/2018 06/06/2018 2
John Smith 02/06/2018 06/06/2018 3

I need a formula to populate the 1st spreadsheet in the column name holiday taken
. Just need to say true or yes

thanks

 

[DanteAmor]

Use the following

Excel Workbook
	A	B	C
1	Date	Employee Name	Holiday taken
2	02/06/2018	Joebloggs	Yes
3	03/06/2018	Joebloggs	Yes
4	06/06/2018	Joebloggs	Yes
5	02/06/2018	JohnSmith	Yes
6	03/06/2018	JohnSmith	Yes
7	06/06/2018	JohnSmith	No
sheet1