Spreadsheet: 861933d1709755314-index-match-formula-not-working-as-expected-examplebook
Sheet: Sheet1

ID | administrationaction | Date | firstindicationforuse | med_admin_department | cost center
1 | Given | 2021-08-10 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
1 | Given | 2021-08-11 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
2 | Given | 2021-08-26 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
2 | Given | 2021-08-27 00:00:00 |  | PICU NW
2 | Given | 2021-08-27 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
3 | Given | 2021-08-23 00:00:00 | ENDOCARDITIS/INTRAVASCULAR INFECTION | PICU NW
3 | Given | 2021-08-24 00:00:00 | ENDOCARDITIS/INTRAVASCULAR INFECTION | PICU NW
3 | Given | 2021-08-24 00:00:00 |  | PICU NW
3 | Given | 2021-08-24 00:00:00 | SEPSIS/BACTEREMIA - SUSPECTED/CONFIRMED | PICU NW
3 | Given | 2021-08-24 00:00:00 | SEPSIS/BACTEREMIA - SUSPECTED/CONFIRMED | PICU NW
3 | Given | 2021-08-25 00:00:00 | SEPSIS/BACTEREMIA - SUSPECTED/CONFIRMED | PICU NW
3 | Given | 2021-08-25 00:00:00 | SEPSIS/BACTEREMIA - SUSPECTED/CONFIRMED | PICU NW
3 | Given | 2021-08-26 00:00:00 | SEPSIS/BACTEREMIA - SUSPECTED/CONFIRMED | PICU NW
3 | Given | 2021-08-26 00:00:00 | SEPSIS/BACTEREMIA - SUSPECTED/CONFIRMED | PICU NW
3 | Given | 2021-08-26 00:00:00 | SEPSIS/BACTEREMIA - SUSPECTED/CONFIRMED | PICU NW
3 | Given | 2021-08-27 00:00:00 | SEPSIS/BACTEREMIA - SUSPECTED/CONFIRMED | PICU NW
3 | Given | 2021-08-27 00:00:00 | SEPSIS/BACTEREMIA - SUSPECTED/CONFIRMED | PICU NW
3 | Given | 2021-08-27 00:00:00 | SEPSIS/BACTEREMIA - SUSPECTED/CONFIRMED | PICU NW
4 | Given | 2021-11-15 00:00:00 |  | PICU NW
4 | Given | 2021-11-16 00:00:00 | PNEUMONIA/SINUSITIS | PICU NW
4 | Given | 2021-11-16 00:00:00 |  | PICU NW
4 | Given | 2021-11-17 00:00:00 | PNEUMONIA/SINUSITIS | PICU NW
4 | Given | 2021-11-17 00:00:00 |  | PICU NW
4 | Given | 2021-11-18 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
4 | Given | 2021-11-18 00:00:00 |  | PICU NW
4 | Given | 2021-11-19 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
4 | Given | 2021-11-20 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
4 | Given | 2021-11-20 00:00:00 | INTRAABDOMINAL/GI INFECTION/APPENDICITIS | PICU NW
4 | Given | 2021-11-21 00:00:00 | INTRAABDOMINAL/GI INFECTION/APPENDICITIS | PICU NW
4 | Given | 2021-11-21 00:00:00 | SEVERE [NAME] INFECTION | PICU NW
4 | Given | 2021-11-22 00:00:00 | SEVERE [NAME] INFECTION | PICU NW
4 | Given | 2021-11-22 00:00:00 | INTRAABDOMINAL/GI INFECTION/APPENDICITIS | PICU NW
4 | Given | 2021-11-23 00:00:00 | SEVERE [NAME] INFECTION | PICU NW
4 | Given | 2021-11-23 00:00:00 | INTRAABDOMINAL/GI INFECTION/APPENDICITIS | PICU NW
4 | Given | 2021-11-24 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
4 | Given | 2021-11-24 00:00:00 | URINARY TRACT INFECTION | PICU NW
4 | Given | 2021-11-24 00:00:00 | INTRAABDOMINAL/GI INFECTION/APPENDICITIS | PICU NW
4 | Given | 2021-11-24 00:00:00 | SEVERE [NAME] INFECTION | PICU NW
4 | Given | 2021-11-25 00:00:00 | URINARY TRACT INFECTION | PICU NW
4 | Given | 2021-11-25 00:00:00 | SEVERE [NAME] INFECTION | PICU NW
4 | Given | 2021-11-26 00:00:00 | SEVERE [NAME] INFECTION | PICU NW
4 | Given | 2021-11-26 00:00:00 | URINARY TRACT INFECTION | PICU NW
4 | Given | 2021-11-26 00:00:00 | URINARY TRACT INFECTION | PICU NW
4 | Given | 2021-11-27 00:00:00 | SEVERE [NAME] INFECTION | PICU NW
4 | Given | 2021-11-27 00:00:00 | URINARY TRACT INFECTION | PICU NW
4 | Given | 2021-11-28 00:00:00 | URINARY TRACT INFECTION | PICU NW
4 | Given | 2021-11-28 00:00:00 | URINARY TRACT INFECTION | PICU NW
4 | Given | 2021-11-28 00:00:00 | SEVERE [NAME] INFECTION | PICU NW
4 | Given | 2021-11-29 00:00:00 | SEVERE [NAME] INFECTION | PICU NW
4 | Given | 2021-11-29 00:00:00 | URINARY TRACT INFECTION | PICU NW
4 | Given | 2021-11-29 00:00:00 | URINARY TRACT INFECTION | PICU NW
4 | Given | 2021-11-30 00:00:00 | SEVERE [NAME] INFECTION | PICU NW
4 | Given | 2021-11-30 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
4 | Given | 2021-11-30 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
4 | Given | 2021-11-30 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
4 | Given | 2021-11-30 00:00:00 | URINARY TRACT INFECTION | PICU NW
4 | Given | 2021-12-01 00:00:00 | URINARY TRACT INFECTION | PICU NW
4 | Given | 2021-12-01 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
4 | Given | 2021-12-01 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
4 | Given | 2021-12-02 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
4 | Given | 2021-12-02 00:00:00 | URINARY TRACT INFECTION | PICU NW
4 | Given | 2021-12-03 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
4 | Given | 2021-12-03 00:00:00 | URINARY TRACT INFECTION | PICU NW
4 | Given | 2023-02-21 00:00:00 | SEPSIS/BACTEREMIA - SUSPECTED/CONFIRMED | PICU NW
4 | Given | 2023-02-21 00:00:00 | PNEUMONIA/SINUSITIS | PICU NW
4 | Given | 2023-02-22 00:00:00 | PNEUMONIA/SINUSITIS | PICU NW
4 | Given | 2023-02-22 00:00:00 | SEPSIS/BACTEREMIA - SUSPECTED/CONFIRMED | PICU NW
4 | Given | 2023-08-09 00:00:00 | INVASIVE CANDIDIASIS | PICU NW
4 | Given | 2023-08-09 00:00:00 | PNEUMONIA/SINUSITIS | PICU NW
4 | Given | 2023-08-10 00:00:00 | INVASIVE CANDIDIASIS | PICU NW
4 | Given | 2023-08-10 00:00:00 | PNEUMONIA/SINUSITIS | PICU NW
4 | Given | 2023-08-11 00:00:00 | PNEUMONIA/SINUSITIS | PICU NW
5 | Given | 2022-11-02 00:00:00 | ANTIINFLAMMATORY | PICU NW
5 | Given | 2022-11-02 00:00:00 | TRACHEITIS | PICU NW
5 | Given | 2022-11-02 00:00:00 | PROPHYLAXIS - MEDICAL/SURGICAL | PICU NW
5 | Given | 2022-11-03 00:00:00 | TRACHEITIS | PICU NW