I am having trouble with either a vlookup or an index/match. I have a table of employees and the days they work. I would like to type the employee serial number and have it result in the data in the row of the date the employee is working.

I included an example.

Thanks for the help.

lookup employee.xlsx