Schedule calendar for vacation tracking

[ExcelNovice]

I am using an excel template "team roster, schedule and calendar". I'm using it to help track vacation requests for my team of 23. It works great except for when I have two or more team members requesting time off for the same day. This happens quite often. The spreadsheet somehow is unable to add two or more names to the same date cell on the calendar.
The way it works is like this: The template has three tabs, the first is Schedule, the second is Roster, and the third is Calendar.
I enter the date of the vacation request in a cell in the date column on the schedule tab, then enter the team member's name in the "Event" column on the schedule tab.
The team member's name is then populated on the calendar on the appropriate date. That's great. The problem is that if I enter the same date again and the name of another team member in another cell in the Date column, nothing happens. I would like to adjust the formula so that the second team member's name will populate on the calendar looking something like this - Susan Brown; Ted Barnes and so on.

The formula being used on the calendar is =IFERROR(IF(VLOOKUP(D14,Table2[[DATE]:[EVENT]],2,FALSE)<>"",VLOOKUP(D14,Table2[[DATE]:[EVENT]],2,FALSE),""),"").

Thanks for your help.

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)