Spreadsheet: 154747d1336547783-return-multiple-results-from-one-column-based-on-cells-in-another-column-chollyfunk-example-workbook
Sheet: Sheet1

MO-VIZ |  | DAY | DAY | DAY | DAY | DAY |  | MO-VIZ |  | DAY | DAY | DAY | DAY | DAY |  | MO-VIZ |  | DAY | DAY | DAY | DAY | DAY |  | MO-VIZ |  | DAY | DAY | DAY | DAY | DAY |  | MO-VIZ
DEEMA | DAY | DAY | DAY | DAY | DAY |  |  | DEEMA | DAY | DAY | DAY | DAY | DAY |  |  | DEEMA | DAY | DAY | DAY | DAY | DAY |  |  | DEEMA | DAY | DAY | DAY | DAY | DAY |  |  | DEEMA
RANIA | DAY | DAY | DAY | DAY | DAY |  |  | RANIA | DAY | DAY | DAY | DAY | DAY |  |  | RANIA | DAY | DAY | DAY | DAY | DAY |  |  | RANIA | DAY | DAY | DAY | DAY | DAY |  |  | RANIA
ALEX |  | DAY | DAY | DAY | DAY | DAY |  | ALEX |  | MID | MID |  |  | MID | MID | ALEX | MID |  |  | MID | MID |  |  | ALEX |  | EARLY | EARLY |  |  | EARLY | EARLY | ALEX
DAWEI | LATE |  |  | LATE | LATE |  |  | DAWEI |  | DAY | DAY | DAY | DAY | DAY |  | DAWEI |  | MID | MID |  |  | MID | MID | DAWEI | MID |  |  | MID | MID |  |  | DAWEI
PIERRE |  | LATE | LATE |  |  | LATE | LATE | PIERRE | LATE |  |  | LATE | LATE |  |  | PIERRE |  | DAY | DAY | DAY | DAY | DAY |  | PIERRE |  | MID | MID |  |  | MID | MID | PIERRE
JJ | EARLY |  |  | EARLY | EARLY |  |  | JJ |  | LATE | LATE |  |  | LATE | LATE | JJ | LATE |  |  | LATE | LATE |  |  | JJ |  | DAY | DAY | DAY | DAY | DAY |  | JJ
YVES |  | EARLY | EARLY |  |  | EARLY | EARLY | YVES | EARLY |  |  | EARLY | EARLY |  |  | YVES |  | LATE | LATE |  |  | LATE | LATE | YVES | LATE |  |  | LATE | LATE |  |  | YVES
OMAR A | MID |  |  | MID | MID |  |  | OMAR A |  | EARLY | EARLY |  |  | EARLY | EARLY | OMAR A | EARLY |  |  | EARLY | EARLY |  |  | OMAR A |  | LATE | LATE |  |  | LATE | LATE | OMAR A
OMAR S |  | MID | MID |  |  | MID | MID | OMAR S | MID |  |  | MID | MID |  |  | OMAR S |  | EARLY | EARLY |  |  | EARLY | EARLY | OMAR S | EARLY |  |  | EARLY | EARLY |  |  | OMAR S
ABDUL | LATE |  |  | LATE | LATE |  |  | ABDUL |  | MID | MID |  |  | MID | MID | ABDUL | MID |  |  | MID | MID |  |  | ABDUL |  | EARLY | EARLY |  |  | EARLY | EARLY | ABDUL
KHAFIE |  | LATE | LATE |  |  | LATE | LATE | KHAFIE | LATE |  |  | LATE | LATE |  |  | KHAFIE |  | MID | MID |  |  | MID | MID | KHAFIE | MID |  |  | MID | MID |  |  | KHAFIE
[NAME] | EARLY |  |  | EARLY | EARLY |  |  | [NAME] |  | LATE | LATE |  |  | LATE | LATE | [NAME] | LATE |  |  | LATE | LATE |  |  | [NAME] |  | MID | MID |  |  | MID | MID | [NAME]
INTAN |  | EARLY | EARLY |  |  | EARLY | EARLY | INTAN | EARLY |  |  | EARLY | EARLY |  |  | INTAN |  | LATE | LATE |  |  | LATE | LATE | INTAN | LATE |  |  | LATE | LATE |  |  | INTAN
DUHA | MID |  |  | MID | MID |  |  | DUHA |  | EARLY | EARLY |  |  | EARLY | EARLY | DUHA | EARLY |  |  | EARLY | EARLY |  |  | DUHA |  | LATE | LATE |  |  | LATE | LATE | DUHA
ISSRA |  | MID | MID |  |  | MID | MID | ISSRA | MID |  |  | MID | MID |  |  | ISSRA |  | EARLY | EARLY |  |  | EARLY | EARLY | ISSRA | EARLY |  |  | EARLY | EARLY |  |  | ISSRA
IWONA |  | DAY | DAY | DAY | DAY | DAY |  | IWONA |  | MID | MID |  |  | MID | MID | IWONA | MID |  |  | MID | MID |  |  | IWONA |  | EARLY | EARLY |  |  | EARLY | EARLY | IWONA
DALIA | LATE |  |  | LATE | LATE |  |  | DALIA |  | DAY | DAY | DAY | DAY | DAY |  | DALIA |  | MID | MID |  |  | MID | MID | DALIA | MID |  |  | MID | MID |  |  | DALIA
FL01 |  | MID | MID |  |  | MID | MID | FL01 | MID |  |  | MID | MID |  |  | FL01 |  | EARLY | EARLY |  |  | EARLY | EARLY | FL01 | EARLY |  |  | EARLY | EARLY |  |  | FL01
FL02 | MID |  |  | MID | MID |  |  | FL02 |  | EARLY | EARLY |  |  | EARLY | EARLY | FL02 | EARLY |  |  | EARLY | EARLY |  |  | FL02 |  | LATE | LATE |  |  | LATE | LATE | FL02
EXAMPLE RESULTS OF STAFF NUMBERS -  THIS IS THE BIT I'D LIKE TO AUTOMATE
EARLY | JJ | YVES | etc
 | [NAME] | INTAN
MID | OMAR A | OMAR S | etc
 | DUHA | ISRAA
 | FL02 | FL01
LATE | DAWEI | PIERRE | etc
 | ABDUL | KHAFIE
 | DALIA
DAY | DEEMA | MO-VIZ | etc
 | RANIA | DEEMA
 |  | RANIA
 |  | ALEX
 |  | IWONA