I am trying to setup 2 worksheets to create a work schedule for a small company. The first worksheet would list all employees and whether they are "in" or "off," and this I would manually input. The second worksheet would search the columns for the day and if they are "in" would pull their name and put it in the seond sheet. The second sheet would be used only for easy viewing to see who was "in" that particular day. I have been trying the VLOOKUP and INDEX/Match function with no luck. What functions should I be using?
Example:
The first is a weekly schedule for employees: the names are in column 1, the days of the week in row 1, and whether an employee is in/off in the table:
Mon Tues Wed
John In Off In
Bill Off IN In
Jane In In Off
Fred In IN IN

The second worksheet:
Mon Tues Wed
John Bill John
Jane Jane Bill
Fred Fred Fred

I hope this makes sense, and would appreciate any direction and assistance.