INDEX MATCH With 2 criteria inc. between date

[MishyWhite]

Hi

I am hoping someone can help me... this is my first post so please bear with me

I am writing what will become a job planner so that i can see what jobs my guys are working on on which days. I have almost got there but i am stuck on the INDEX MATCH. I have a raw data tab showing (sorry, can't seem to upload a pic) :

DayCode	Job Number	Action	Start Date	End Date	Month	Engineer	Team
Dave Smith03/01/17	146-15-DW003	Meeting	03/01/17	03/01/17	1.00	Dave Smith	Maintenance & SW
Dave Smith03/10/16		Meeting	03/10/16	03/10/16	10.00	Dave Smith	Maintenance & SW
Dave Smith05/01/17	1190-14-DW066	Meeting	05/01/17	05/01/17	1.00	Dave Smith	Maintenance & SW
Dave Smith07/01/17	1190-14-DW066	Meeting	07/01/17	19/01/17	1.00	Dave Smith	Maintenance & SW

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

I then have a seperate tab to show the job per person, per day :

	01/01/17	02/01/17	03/01/17	04/01/17	05/01/17	06/01/17	07/01/17
Andy Smith
Dave Smith			146-15-DW003		1190-14-DW066		1190-14-DW066
Andrew ****sedge
Ed Peters
John King			15845615321	15845615321	15845615321		15845615321
Kevin Jones
Michelle Jenkins			15845615321

<colgroup><col><col span="7"></colgroup><tbody>
</tbody>

So i have managed to get the jobs tab to lookup the person and the date (concatenated) and get the job number - =IFERROR(INDEX(RawData!$A:$I,MATCH($A7&B$5,RawData!$A:$A,0),2),"")

But what i really need to do is to look at the plan date for that person and if that date falls between the start and end date to show the job number. The added complication is that there may be more than one job for that person on that day so i'm not sure how to get around that but for now just the first job on tat day will suffice. I hope i have explained myself well enough but please let me know if i haven't... any help would be gratefully received, thanks