INDEX MATCH Function for Calendar Schedule

Hi all,

Hoping I can get some quick help on a relatively simple request. I am trying to adapt an excel calendar template to show the schedule and timing of employees vacation and proposed visit dates. Originally the template used VLOOKUP to refer to the schedule to place the applicable EVENT description in the calendar format; however, I am anticipating having multiple events on one date and therefore need to adapt the VLOOKUP to use INDEX MATCH I believe. I have tried to no avail to figure out how to use this function. For example to state that from July 9 to 13 two people will be out of the office instead of one.

Can anyone help?!

Thanks,

N

Attached is example of a calendar allowing several "activities" per day:

Thanks for you response John, but I can't access the file. I get an error message that the file format or file extension is not valid. Could you please resend?

Try this version