Spreadsheet: 731129d1620206390-find-column-title-in-a-range-and-return-the-title-of-that-column-excel-forum-example
Sheet: Sheet1

 |  | Start | End
Rota period: |  | 2021-07-05 00:00:00 | 2021-10-24 00:00:00
 |  |  | Early | Early Extra | USS | MIU/paeds | Late | Twilight | Twilight | Night | Night 2
 |  |  | 0800-1730 | 0800-1730 | 0800-1730 | 0800-1730 | 1300-2230* | 1700-0200 | 1700-0200 | 2200-0830 | 2200-0830 | Notes
Week 1 |  |  | Ray | [NAME] | [NAME] | [NAME] | Ashraf | [NAME] |  | Ahmed
 |  |  | Ray | [NAME] |  |  | Ashraf | [NAME] | [NAME] | Ahmed
 |  |  | [NAME] | Ravi |  |  | Ray | [NAME] | [NAME] | Anna
 |  |  | Martin | [NAME] |  |  | Pranav | [NAME] | [NAME] | Anna
 |  |  | Ashraf | Ravi |  |  | Pranav | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  | Ashraf |  |  |  | Ahmed | [NAME] |  | [NAME] | [NAME]
 |  |  | Ashraf |  |  |  | Ahmed | [NAME] |  | [NAME] | [NAME]
Week 2 |  |  | Ravi | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  | Ravi | [NAME] |  |  | Ashraf | [NAME] | [NAME] | [NAME]
 |  |  | [NAME] |  |  |  | [NAME] | Ashraf | [NAME] | [NAME]
 |  |  | Martin | [NAME] |  |  | Ahmed | [NAME] | Pranav | [NAME]
 |  |  | [NAME] |  |  |  | Ahmed | [NAME] | Pranav | [NAME]
 |  |  | [NAME] |  |  |  |  | [NAME] |  | [NAME]
 |  |  | [NAME] |  |  |  |  | [NAME] |  | [NAME]
Week 3 |  |  | [NAME] |  |  | [NAME] |  | [NAME]
 |  |  | [NAME] | Ravi |  |  |  | [NAME] |  |  | Martin
 |  |  | Ashraf | Ravi |  |  | Ahmed | [NAME] |  |  | Martin
 |  |  | Ashraf | [NAME] |  |  | Ahmed | [NAME] |  |  | Martin
 |  |  | Ashraf |  |  | [NAME] | Pranav | Ravi |  | [NAME]
 |  |  | [NAME] |  |  |  | Pranav | Ravi |  | [NAME]
 |  |  | [NAME] |  |  |  | Pranav | Ravi |  | [NAME]
Week 4 |  |  | [NAME] |  |  |  | Ashraf | [NAME] |  | [NAME]
 |  |  | [NAME] |  |  | Anna | Ashraf | [NAME] |  | [NAME]
 |  |  | Anna | [NAME] |  |  | Ashraf | Ahmed |  | [NAME]
 |  |  | [NAME] | Anna |  |  | Ravi | Ahmed |  | [NAME]
 |  |  | Pranav |  |  |  | Ravi | Anna |  | [NAME] | [NAME]
 |  |  | Ashraf |  |  |  | Ray | Anna |  | [NAME] | [NAME]
 |  |  | Pranav |  |  |  | Ray | Anna |  | [NAME] | [NAME]
Week 5 |  |  | Ravi |  |  | [NAME] |  | [NAME] | Anna | Ahmed
 |  |  | Ravi |  |  |  |  | [NAME] | [NAME] | Ahmed
 |  |  | Ravi | Emily |  |  |  | [NAME] | [NAME] | [NAME] |  | INDUCTION
 |  |  | Anna |  |  |  | Ravi | [NAME] | [NAME] | [NAME] |  | INDUCTION
 |  |  | Pranav | Eleanor |  |  |  | [NAME] | Anoop | Anna | [NAME]
 |  |  | Pranav |  |  |  |  | [NAME] | Anoop | Anna | [NAME]
 |  |  | Pranav |  |  |  |  | [NAME] | Anoop | Anna | [NAME]
Week 6 |  |  | Emily | [NAME] |  |  | Ahmed | Bilal | Katrina | [NAME]
 |  |  | Emily | Eleanor |  | [NAME] | Ahmed | Bilal | Katrina | [NAME]
 |  |  | [NAME] | Emily |  |  | Ahmed | Bilal | Pranav | [NAME]
 |  |  | [NAME] | Anna |  |  | Martin | Bilal | Pranav | [NAME]
 |  |  | Ravi | [NAME] | Anoop | [NAME] | Martin | Anna | [NAME] | [NAME] | Katrina
 |  |  | Ravi |  |  |  |  | Anna | [NAME] | [NAME] | Katrina
 |  |  | Ravi |  |  |  |  | Anna | [NAME] | [NAME] | Katrina
Week 7 |  |  | [NAME] |  |  |  |  | [NAME] | Anna | Anoop | [NAME]
 |  |  | [NAME] |  |  | [NAME] | Ravi | [NAME] | [NAME] | Anoop | [NAME]
 |  |  | [NAME] | [NAME] |  |  | Ravi | [NAME] | [NAME] | Anoop
 |  |  | Martin | Anna |  |  | Ravi | [NAME] | [NAME] | Anoop
 |  |  | [NAME] |  |  | Anna | Pranav | Emily |  | Bilal | [NAME]
 |  |  | [NAME] |  |  |  |  | Emily |  | Bilal | [NAME]
 |  |  | [NAME] |  |  |  |  | Emily |  | Bilal | [NAME]
Week 8 |  |  | [NAME] | Anna |  |  |  | [NAME] | Anoop | Eleanor
 |  |  | Pranav | Anna |  | [NAME] | Ravi | [NAME] | Anoop | Eleanor
 |  |  | Anna | [NAME] | Bilal |  | Ravi | [NAME] | Katrina | Eleanor | Pranav
 |  |  | Martin | Bilal |  |  | Ravi | [NAME] | Katrina | [NAME] | Pranav
 |  |  | Anna |  |  | [NAME] | Ravi | [NAME] |  | [NAME] | Anoop
 |  |  | [NAME] |  |  |  |  | [NAME] |  | [NAME] | Anoop
 |  |  | [NAME] |  |  |  |  | [NAME] |  | [NAME] | Anoop
Week 9 |  |  | Ravi | Katrina |  | Eleanor |  | Emily |  | Anna |  | Bank holiday
 |  |  | Ravi | Eleanor |  | Katrina |  | Emily |  | Anna | Martin
 |  |  | Ravi | Eleanor | Katrina |  | Ahmed | Anoop |  | Anna | Martin | Induction
 |  |  | Katrina |  | [NAME] |  | Ahmed | Anoop |  | [NAME] | Martin | Induction
 |  |  | Katrina |  |  | [NAME] |  | Bilal |  | [NAME] | Eleanor
 |  |  | [NAME] |  |  |  |  | Bilal |  | [NAME] | Eleanor
 |  |  | [NAME] |  |  |  |  | Bilal |  | [NAME] | Eleanor
Week 10 |  |  | Ravi | Katrina |  | Anoop |  | Bilal |  | [NAME]
 |  |  | Ravi | Katrina |  | Emily |  | Anoop |  | [NAME]
 |  |  | Ravi |  |  |  |  | Anoop |  | [NAME] |  | WREMTA (TBC)
 |  |  | Martin | Bilal |  |  |  | Emily |  | [NAME] | Katrina
 |  |  | Bilal |  |  | Anoop | Ravi | Ahmed |  | [NAME] | Katrina
 |  |  | [NAME] |  |  |  | Ravi | Ahmed |  | [NAME] | Katrina
 |  |  | [NAME] |  |  |  | Ravi | Ahmed |  | [NAME] | Katrina
Week 11 |  |  | Anoop |  |  |  |  | [NAME] | Eleanor | Bilal
 |  |  | Anoop |  |  |  |  | [NAME] | Eleanor | Bilal
 |  |  | Ravi | [NAME] | Anoop |  | Ahmed | [NAME] | Eleanor | Bilal
 |  |  | Ravi | Katrina |  |  | Ahmed | [NAME] | Eleanor | Bilal
 |  |  | Ravi | [NAME] |  | Katrina |  | Eleanor |  | Emily | Anoop
 |  |  | Martin |  |  |  |  | Eleanor |  | Emily | Anoop
 |  |  | Martin |  |  |  |  | Eleanor |  | Emily | Anoop
Week 12 |  |  | Ravi | [NAME] | [NAME] | Eleanor |  | Bilal |  | [NAME]
 |  |  | Ravi | Eleanor | [NAME] | [NAME] | Ahmed | Bilal |  | [NAME]
 |  |  | Ravi | [NAME] |  |  | Ahmed | Bilal |  | [NAME] |  | WREMTA (TBC)
 |  |  | Ravi | Eleanor |  |  | Martin | Bilal |  | [NAME] | Katrina
 |  |  | [NAME] |  |  | Eleanor | Martin | [NAME] |  | Katrina
 |  |  | [NAME] |  |  |  |  | [NAME] |  | Katrina
 |  |  | [NAME] |  |  |  |  | [NAME] |  | Katrina
Week 13 |  |  | Ravi |  |  | Bilal |  | [NAME] |  | Anoop
 |  |  | Ravi | Bilal |  |  |  | [NAME] |  | Anoop
 |  |  | Ravi |  |  |  | Ahmed | [NAME] | [NAME] | Anoop
 |  |  | Martin | Katrina |  |  | Ahmed | [NAME] | [NAME] | Bilal
 |  |  | Ravi | Katrina |  |  |  | Emily |  | Bilal | [NAME]
 |  |  | Ravi |  |  |  |  | Emily |  | Bilal | [NAME]
 |  |  | Ravi |  |  |  |  | Emily |  | Bilal | [NAME]
Week 14 |  |  | Anoop | [NAME] |  |  |  | Katrina |  | Eleanor | [NAME]
 |  |  | Anoop | [NAME] |  |  |  | Katrina |  | Eleanor
 |  |  | Anoop | [NAME] |  |  | Ravi | Katrina |  | Eleanor
 |  |  | Martin | Emily | Bilal |  | Ravi | Katrina |  | Eleanor
 |  |  | Bilal | [NAME] |  | Emily | Ravi | Ahmed | Anoop | [NAME]
 |  |  | Bilal |  |  |  |  | Ahmed | Anoop | [NAME]
 |  |  | Bilal |  |  |  |  | Ahmed | Anoop | [NAME]
Week 15 |  |  | Bilal | Eleanor |  | [NAME] |  | [NAME] |  | Emily
 |  |  | Pranav | Eleanor | [NAME] | Bilal |  | [NAME] |  | Emily | Martin
 |  |  | Pranav | Ravi |  |  | [NAME] | [NAME] |  | Emily | Martin | WREMTA (TBC)
 |  |  | Pranav | Ravi |  |  |  | [NAME] |  | Emily | Martin
 |  |  | Anoop | Ravi |  |  |  | Katrina |  | [NAME] | Eleanor
 |  |  | Anoop |  |  |  |  | Katrina |  | [NAME] | Eleanor
 |  |  | Anoop |  |  |  |  | Katrina |  | [NAME] | Eleanor
Week 16 |  |  | Anoop |  |  | Emily | Pranav | [NAME] |  | [NAME]
 |  |  | Anoop | Ravi |  |  | Pranav | [NAME] |  | [NAME]
 |  |  | [NAME] |  |  |  | Ravi | [NAME] |  | [NAME]
 |  |  | Martin | Katrina |  |  | Ravi | [NAME] |  | [NAME]
 |  |  | Pranav | [NAME] |  | Katrina | Ravi | Eleanor |  | Emily | [NAME]
 |  |  | [NAME] |  |  |  |  | Eleanor |  | Emily | [NAME]
 |  |  | [NAME] |  |  |  |  | Eleanor |  | Emily | [NAME]