Index/Match Help - Google Sheets

Hi There!

Everyone in this forum is so fantastic and I'm hoping someone can help again.

I have a spreadsheet that I'm trying to use a billing tab to populate a summary tab. On the attached spreadsheet - I want to populate the Schedule Summary tab, with the sales person's name on the appropriate date they've signed up for based on the May Tab. I've also added a desired result tab as an example of what I wanted it to look like.

I've been able to get it to work for one line by using this formula -

Formula:

Please Login or Register  to view this content.

but when I copy it down, it doesn't work properly for the next results - it gives me blank cells, instead of finding the next hit that meets the requirements.

I'm guessing I need to use an index/match formula, but haven't been able to get it to work. I've also tried this formula, but it did not work, it gave me a result of "0".

Formula:

Please Login or Register  to view this content.

Also to note - the attachment is in Excel, but I need it to work in google sheets.

Help Please!

Thank you!!!