Spreadsheet: 724211d1616076426-look-up-data-dependent-on-multiple-criteria-data-lookup-test-data
Sheet: Test Example

Ticket no. | Mapped Status | Status start | Status end | Current status? | Status Start Copy
100001 | New | 2019-12-18 15:42:22 | 2019-12-18 15:54:51
100001 | Under Investigation | 2019-12-18 15:54:51 | 2019-12-18 16:49:09 |  |  | False
100001 | Waiting for Customer | 2019-12-18 16:49:09 | 2019-12-27 11:49:10 |  |  | False
100001 | Resolved | 2019-12-27 11:49:10 | 2020-02-17 11:56:02 |  |  | False
100001 | Under Investigation | 2020-02-17 11:56:02 | 2020-02-17 12:04:09 |  |  | False
100001 | Under Investigation | 2020-02-17 12:04:09 | 2020-02-17 12:10:18 |  |  | False
100001 | Under Investigation | 2020-02-17 12:10:18 | 2020-02-17 13:53:09 |  |  | False
100001 | Under Investigation | 2020-02-17 13:53:09 | 2020-02-17 13:53:47 |  |  | False
100001 | 2nd Line | 2020-02-17 13:53:47 | 2020-02-17 13:53:52 |  |  | False
100001 | Under Investigation | 2020-02-17 13:53:52 | 2020-11-12 14:14:36 |  |  | False
100001 | Resolved | 2020-11-12 14:14:36 | 2020-11-17 11:14:36 |  |  | False
100001 | Resolved | 2020-11-17 11:14:36 |  | Y |  | False
100002 | New | 2019-12-18 15:45:23 | 2019-12-18 15:47:39 |  |  | False
100002 | Under Investigation | 2019-12-18 15:47:39 | 2019-12-19 09:06:54 |  |  | False
100002 | Resolved | 2019-12-19 09:06:54 | 2019-12-19 09:06:56 |  |  | False
100002 | Under Investigation | 2019-12-19 09:06:56 | 2019-12-19 09:39:15 |  |  | False
100002 | Under Investigation | 2019-12-19 09:39:15 | 2019-12-19 09:39:18 |  |  | False
100002 | Resolved | 2019-12-19 09:39:18 | 2019-12-19 09:48:16 |  |  | False
100002 | Under Investigation | 2019-12-19 09:48:16 | 2019-12-19 09:48:28 |  |  | False
100002 | Under Investigation | 2019-12-19 09:48:28 | 2019-12-19 09:53:41 |  |  | False
100002 | 2nd Line | 2019-12-19 09:53:41 | 2019-12-30 11:44:37 |  |  | False
100002 | Under Investigation | 2019-12-30 11:44:37 | 2019-12-30 11:49:38 |  |  | False
100002 | Resolved | 2019-12-30 11:49:38 | 2019-12-30 11:49:39 |  |  | False
100002 | Under Investigation | 2019-12-30 11:49:39 | 2019-12-30 11:59:17 |  |  | False
100002 | Under Investigation | 2019-12-30 11:59:17 | 2019-12-30 11:59:20 |  |  | False
100002 | Resolved | 2019-12-30 11:59:20 | 2020-01-02 17:29:21 |  |  | False
100002 | Resolved | 2020-01-02 17:29:21 |  | Y |  | False
(1) |  |  |  | [NAME] in Each Month
Ticket no. |  | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00
100001
100002
(2)
 |  |  |  | [NAME],Status and Status Start Date then returns the start date
Ticket no. | Status | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00
100001 | New
100001 | Under Investigation
100001 | 2nd Line
100001 | Prod Issue
100001 | Waiting for Customer
100001 | Suggestion
100001 | Resolved
100002 | New
100002 | Under Investigation
100002 | 2nd Line
100002 | Prod Issue
100002 | Waiting for Customer
100002 | Suggestion
100002 | Resolved