M
Matt
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(Day!$A$1:$A$4,MATCH(A1,Day!$B$1:$B$4,0)))
Can I nest a Row formula +1?
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(Day!$A$1:$A$4,MATCH(A1,Day!$B$1:$B$4,0)))
Can I nest a Row formula +1?