Confused- Should I use Lookup, Match, Index?

Hello,

I have a spreadsheet I'm using for schedules and I've hit a roadblock.

Every day I need to create a list of employees scheduled, and historically this has been done by hand after referencing a file with the schedules. I want to automate the process, so by entering the date you'll return every employee scheduled that day in a list.

I have a workbook with two sheets- sheet 1 is the list of employees, sheet two is the schedules.

What I'm doing is using the unique employee numbers listed on both sheets combined with the date to create a new, unique number that can be searched for on sheet 2, then I need to return the results for the 2 columns immediately after that number to sheet 1 (start and end time).

I was able to do this succesfully by making all of the data vertical, and using vlookup- but it isn't very user friendly for the person entering the schedules- so I was hoping there was a way to do it differently.

TL;DR Version- How can I search for a number anywhere on sheet 2, and return the adjacent cell to sheet 1?

Document attached for review.

That was exactly what I needed! Thank you so much, I spent way too many hours trying to figure this out on my own- and you solved it in 5 minutes.

I'm truly grateful!