Help VLookup & Blank cells

Hi all!

I have a slight problem I've been trying to work on for a while.


I currently have two excel tabs one with day plans and one with a master rota.

The master rota has a list of people and the hours they work for the week.
It's laid out like

Master rota

Name	Monday		Tuesday
Fred
John	8:00	17:00	9:00	17:00

The second tab has something called a day plan which has another table.

What I need in the table is the persons name who's in for that day and the hours they are working.

Day plan

Name	Start time	End time	Lunch (Empty field)
Fred
John	8:00	17:00

So I've done a VLookup in both the Start time & End time which will read the name from the Name field and then add the start time and the end time.

What I want is the the Name field to be automatically filled in for each different day in the day plan.
I'm not explaining this well but if there is an empty field in the start time or end time on the Main rota then I don't want there name in the Dayplan for that day.
Example: John is working Monday 8:00 - 17:00 but isn't working Tuesday but is working wednesday 8:00 - 17:00 Therefore his name should appear on the dayplan for Monday & Wednesday but Not for Tuesday.

I hope I explained that well enough... I know I need somesort of IF command but I just can't figure it out.
Thanks!

Bump

I know I'm not allowed to bump but I'm really desperate for an answer.
Again apologises I won't bump again.

https://docs.google.com/a/johnlewis....it?usp=sharing

I use google sheets
That is a smaller version of what I'm trying to do.

I want the names to automatically pop up when there isn't a gap in the start time and end time for that day.
I hope this clears things up

Anyone who can help please request access

Thanks

Apologises!
I don't have access to Microsoft Excel ATM and this is the only method I know of sharing a sheet.

Thank you for your time

Edit: I haven't put a day plan in for everyday as I'm hoping two days should explain what I'm trying to accomplish.

I hope I'm explaining this well