[SOLVED]Trying to use Index/Match to populate daily Work Line up based on a schedule

Hello Everyone,

This is my first post.

I am trying to setup a Daily Line Up based on the weekly schedule (in the second sheet of workbook) as the reference. I want the "SHIFT" column to populate the corresponding employee's schedule (once picked from the drop down list B29:B57) for the date populated in the K1 Cell(The NOW() function is used in the cell).

How can this be done?

I have attached the workbook.

Thanks in advance

cannot see any drop downs

Sorry, must have uploaded wrong wrkbk

try this, copied down...
=INDEX(WeeklySchedule!$B$3:$I$79,MATCH(LineUp!$C29,WeeklySchedule!$B$3:$B$79,0),MATCH(LineUp!$K$1,WeeklySchedule!$B$3:$I$3,0))

but 1st, change the =now() in sheet1 K1 to =today() =now included the time as well as the date

yeah why not makes it look nice and purdy

da widdle baby in da cash-back commercial? oh, no wait, that was cash-back she didnt like lol