Thanx for the quick response guys.
Maxs solution returns a 0 if one of the cells in Day Col B is empty and
Hectors returns #NUM!. There will be days when an employee is off and I want
the cell on Monday's sheet to remain blank. I have tried to elevate this but
cannot, do anyone have a solutions.


"Matt" wrote:

I am creating a schedule spreadsheet with sheets for everyday of the week and
the shifts. On the sheet listed €œDay€� I have Names in column A, Sections in
column B (ex would be W, E, HLS). On the sheet €œMonday€� in column A is a list
of sections (ex is W,W and E,E). I need to have the various names listed by
the assigned areas.

Before After Forumla
Sheet Day Sheet Monday Sheet Monday
Col A Col B Col A Col B Col A Col B
Jon W W W Jon
Pam E W W Tom
Tom W E E Pam
Nick E E E Nick

I could use the following formula in Monday B1 but it would return the same
name in B2.
=IF(ISNA(MATCH(A1,Day!$B$1:$B$4,FALSE)),"",INDEX(D ay!$A$1:$A$4,MATCH(A1,Day!$B$1:$B$4,0)))
Can I nest a Row formula +1?