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?