Spreadsheet: 154756d1336554128-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 | YVES | JJ | JJ | YVES | YVES |  | YVES | OMAR A | OMAR A | YVES | YVES | OMAR A | OMAR A |  | OMAR A | OMAR S | OMAR S | OMAR A | OMAR A | OMAR S | OMAR S |  | OMAR S | ALEX | ALEX | OMAR S | OMAR S | ALEX | ALEX
 | [NAME] | INTAN | INTAN | [NAME] | [NAME] | INTAN | INTAN |  | INTAN | DUHA | DUHA | INTAN | INTAN | DUHA | DUHA |  | DUHA | ISSRA | ISSRA | DUHA | DUHA | ISSRA | ISSRA |  | ISSRA | ABDUL | ABDUL | ISSRA | ISSRA | ABDUL | ABDUL
 |  |  |  |  |  |  |  |  |  | FL02 | FL02 |  |  | FL02 | FL02 |  | FL02 | FL01 | FL01 | FL02 | FL02 | FL01 | FL01 |  | FL01 | IWONA | IWONA | FL01 | FL01 | IWONA | IWONA
MID | OMAR A | OMAR S | OMAR S | OMAR A | OMAR A | OMAR S | OMAR S |  | OMAR S | ALEX | ALEX | OMAR S | OMAR S | ALEX | ALEX |  | ALEX | DAWEI | DAWEI | ALEX | ALEX | DAWEI | DAWEI |  | DAWEI | PIERRE | PIERRE | DAWEI | DAWEI | PIERRE | PIERRE
 | DUHA | ISSRA | ISSRA | DUHA | DUHA | ISSRA | ISSRA |  | ISSRA | ABDUL | ABDUL | ISSRA | ISSRA | ABDUL | ABDUL |  | ABDUL | KHAFIE | KHAFIE | ABDUL | ABDUL | KHAFIE | KHAFIE |  | KHAFIE | [NAME] | [NAME] | KHAFIE | KHAFIE | [NAME] | [NAME]
 | FL02 | FL01 | FL01 | FL02 | FL02 | FL01 | FL01 |  | FL01 | IWONA | IWONA | FL01 | FL01 | IWONA | IWONA |  | IWONA | DALIA | DALIA | IWONA | IWONA | DALIA | DALIA |  | DALIA |  |  | DALIA | DALIA
LATE | DAWEI | PIERRE | PIERRE | DAWEI | DAWEI | PIERRE | PIERRE |  | PIERRE | JJ | JJ | PIERRE | PIERRE | JJ | JJ |  | JJ | YVES | YVES | JJ | JJ | YVES | YVES |  | YVES | OMAR A | OMAR A | YVES | YVES | OMAR A | OMAR A
 | ABDUL | KHAFIE | KHAFIE | ABDUL | ABDUL | KHAFIE | KHAFIE |  | KHAFIE | [NAME] | [NAME] | KHAFIE | KHAFIE | [NAME] | [NAME] |  | [NAME] | INTAN | INTAN | [NAME] | [NAME] | INTAN | INTAN |  | INTAN | DUHA | DUHA | INTAN | INTAN | DUHA | DUHA
 | DALIA |  |  | DALIA | DALIA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FL02 | FL02 |  |  | FL02 | FL02
DAY | DEEMA | MO-VIZ | MO-VIZ | MO-VIZ | MO-VIZ | MO-VIZ |  |  | DEEMA | MO-VIZ | MO-VIZ | MO-VIZ | MO-VIZ | MO-VIZ |  |  | DEEMA | MO-VIZ | MO-VIZ | MO-VIZ | MO-VIZ | MO-VIZ |  |  | DEEMA | MO-VIZ | MO-VIZ | MO-VIZ | MO-VIZ | MO-VIZ
 | RANIA | DEEMA | DEEMA | DEEMA | DEEMA | ALEX |  |  | RANIA | DEEMA | DEEMA | DEEMA | DEEMA | DAWEI |  |  | RANIA | DEEMA | DEEMA | DEEMA | DEEMA | PIERRE |  |  | RANIA | DEEMA | DEEMA | DEEMA | DEEMA | JJ
 |  | RANIA | RANIA | RANIA | RANIA | IWONA |  |  |  | RANIA | RANIA | RANIA | RANIA | DALIA |  |  |  | RANIA | RANIA | RANIA | RANIA |  |  |  |  | RANIA | RANIA | RANIA | RANIA
 |  | ALEX | ALEX | ALEX | ALEX |  |  |  |  | DAWEI | DAWEI | DAWEI | DAWEI |  |  |  |  | PIERRE | PIERRE | PIERRE | PIERRE |  |  |  |  | JJ | JJ | JJ | JJ
 |  | IWONA | IWONA | IWONA | IWONA |  |  |  |  | DALIA | DALIA | DALIA | DALIA