Spreadsheet: 161771d1339617504-three-conditions-and-how-to-solve-them-without-the-if-function-copy-of-weekly-and-daily-rosters-example
Sheet: Monday

 | DAILY ROSTERS
 |  |  | WEEK 1 |  |  | DATE :
 |  |  |  |  |  |  |  |  |  |  |  | The "BUFFET" String as seem in the previous tab has 4 entries. These, as discussed in the post, need to have three-way sorting before deciding which goes where.
 | Morning Shift
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C
 | TEAM LEADER |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME] | BUFFET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 17:30:00 | 01:00:00
 | BUFFET |  |  | - |  |  |  | -
 | LG1 |  |  | - |  |  |  | -
 | LG2 |  |  | - |  |  |  | - |  |  |  | 1. Match |  |  |  |  |  |  |  |  |  | If the subject “x” is a match then part one is satisfied. (eg. =IF(“B1=”BUFFET”,[Use],””))
 | LG3 |  |  | - |  |  |  | - |  |  |  | =IF(B1=”x”,[Use],””)
 | LG4 |  |  | - |  |  |  | -
 | BARRISTA |  |  | - |  |  |  | - |  |  |  | 2. TIME |  |  |  |  |  |  |  |  |  | If that is satisfied, if the time is between 3AM and 11AM (Morning Shift), then the second part is satisfied. (eg. =IF(B2=[03:00~11:00],[Use],””))
 | DISHES |  |  | - |  |  |  | - |  |  |  | =IF(-a-=03:00~11:00,[Use],””)
 | DISHES 2 |  |  | - |  |  |  | -
 | FOOD PREP |  |  | - |  |  |  | - |  |  |  | 3. SAME |  |  |  |  |  |  |  |  |  | Finally if the previous two conditions are satisfied then, if “x” occurs twice (as in the case of a person’s usual shift being short
 | FOOD PREP |  |  | - |  |  |  | - |  |  |  | =IF(“x”=[Occurs Twice],[Write First/Second Instance],[Write First Instance]) |  |  |  |  |  |  |  |  |  | and a second person working) then in the left hand table write the second instance and the right hand table the first instance
 | CHAIRMANS |  |  | - |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  | or in the case of only one match just write in the left hand table and leave the right blank.
 |  |  |  |  |  |  |  |  |  |  |  | =INDEX([Range of values], SMALL(IF([Value to match]=[Range containing Match], ROW([Range containing Match])-MIN(ROW([Range containing [NAME], ""), COLUMN(A1)))
 |  |  |  |  |  |  |  |  |  |  |  | There is only a possibility that a maximum of 4 entries will appear on any one 'Job'. At most two in the Morning and two in the Afternoon.
 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Ideally, in fact hopefully, I wish to have these organinsed as follows…
 | TEAM LEADER
 |  |  |  |  |  |  |  |  |  |  |  | Morning Shift
 | BUFFET |  |  | - |  |  |  | -
 | LG1 |  |  | - |  |  |  | - |  |  |  | BUFFET | Name | [First Shift] - (0345~) |  |  | Name | [Second Shift] - (~1430)
 | LG2 |  |  | - |  |  |  | -
 | LG3 |  |  | - |  |  |  | -
 | LG4 |  |  | - |  |  |  | - |  |  |  | [NAME]
 | LG5 |  |  | - |  |  |  | -
 | DISHES |  |  | - |  |  |  | - |  |  |  | BUFFET | Name | [Third Shift] - (1430~) |  |  | Name | [Fourth Shift] - (~0100)
 | BAR |  |  | - |  |  |  | -
 | BAR 2 |  |  | - |  |  |  | -
 | BAR 3 |  |  | - |  |  |  | - |  |  |  | Most of the time there are only one morning and one afternoon shift and if this happens then the cells to the right should remain blank.
 | GLASSY |  |  | - |  |  |  | -
 | CHAIRMANS |  |  | - |  |  |  | -
 | DAILY COMMENTS
 | RDO
 | LRDO
 | TRDO