Spreadsheet: 680956d1591277690-pull-multiple-rows-out-of-data-with-two-criteria-list-test-book
Sheet: Sheet1

 | Name | User | Material | Conf.t. | [NAME] | Dest. Bin | [NAME] | Plnt | TO Number | Item | Conf.date | Actual qty | shift | department |  |  |  | Name | Hawkins, Quintis |  | Date | 2020-05-01 00:00:00
 | Hawkins, Quintis | HAWKINSQ | 3332128S.020 | 00:00:46 | R38 | 81S044 | BU3 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 12 | 2nd | Outbound
 | Hawkins, Quintis | HAWKINSQ | 3332128S.020 | 00:02:10 | R38 | 81S044 | BU3 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 12 | 2nd | Outbound
 | Hawkins, Quintis | HAWKINSQ | 3332128S.020 | 00:03:08 | R38 | 81S044 | BU3 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 12 | 2nd | Outbound
 | Hawkins, Quintis | HAWKINSQ | 3332128S.020 | 00:04:53 | R38 | 81S044 | BU3 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 12 | 2nd | Outbound |  |  |  |  | Result |  |  |  | How it should look
 | Hawkins, Quintis | HAWKINSQ | 3332128S.020 | 00:06:00 | R38 | 81S044 | BU3 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 12 | 2nd | Outbound |  |  |  |  | HAWKINSQ | 3332128S.020 | 00:00:46
 | Hawkins, Quintis | HAWKINSQ | 3332128S.020 | 00:08:06 | R38 | 81S044 | BU3 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 12 | 2nd | Outbound |  |  |  |  | HAWKINSQ | 3332128S.020 | 00:02:10
 | Hawkins, Quintis | HAWKINSQ | 3332128S.020 | 00:12:10 | R38 | 81S044 | BU3 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 12 | 2nd | Outbound |  |  |  |  | HAWKINSQ | 3332128S.020 | 00:03:08
 | Hawkins, Quintis | HAWKINSQ | 3332128S.020 | 00:13:23 | R38 | 81S044 | BU3 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 12 | 2nd | Outbound |  |  |  |  | HAWKINSQ | 3332128S.020 | 00:04:53
 | Hawkins, Quintis | HAWKINSQ | 3332128S.020 | 00:13:55 | R38 | 81S044 | BU3 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 12 | 2nd | Outbound |  |  |  |  | HAWKINSQ | 3332128S.020 | 00:06:00
 | Hawkins, Quintis | HAWKINSQ | 3332128S.020 | 00:15:29 | R38 | 81S044 | BU3 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 12 | 2nd | Outbound |  |  |  |  | HAWKINSQ | 3332128S.020 | 00:08:06
 | Green, [NAME] | GREENA | 3332128S.020 | 00:17:44 | R38 | 81S044 | BU3 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 12 | 2nd | Inbound |  |  |  |  | HAWKINSQ | 3332128S.020 | 00:12:10
 | Green, [NAME] | GREENA | 3332128S.020 | 00:18:06 | R38 | 81S044 | BU3 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 12 | 2nd | Inbound |  |  |  |  | HAWKINSQ | 3332128S.020 | 00:13:23
 | Green, [NAME] | GREENA | 3332128S.020 | 00:18:43 | R38 | 81S044 | BU3 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 12 | 2nd | Inbound |  |  |  |  | HAWKINSQ | 3332128S.020 | 00:13:55
 | Guevara, Jorge | [NAME] | 2403128.021 | 04:35:02 | R91 | 37N054 | BU1 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 8 | 1st | Inbound |  |  |  |  | HAWKINSQ | 3332128S.020 | 00:15:29
 | Piedra, [NAME] | PIEDRAR | 2234001.020 | 04:36:09 | R91 | 49SL065 | BU4 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 18 | 1st | Inbound
 | Piedra, [NAME] | PIEDRAR | 2234001.020 | 04:39:18 | R91 | 49SL065 | BU4 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 18 | 1st | Inbound |  |  |  |  |  |  |  | This is what I am getting
 | council, [NAME] | COUNCILR | 7741000.020 | 04:39:24 | R85 | 37N080 | FB1 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 5 | 1st | Inbound
 | Piedra, [NAME] | PIEDRAR | 2234001.020 | 04:41:46 | R91 | 49SL065 | BU4 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 10 | 1st | Inbound
 | Guevara, Jorge | [NAME] | 2403128.021 | 04:42:24 | R91 | 37N054 | BU1 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 7 | 1st | Inbound
 | council, [NAME] | COUNCILR | 7741000.020 | [NAME] | R85 | 37N080 | FB1 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 5 | 1st | Inbound
 | Guevara, Jorge | [NAME] | 2403128.020 | 04:47:32 | R91 | 45N061 | BU1 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 1 | 1st | Inbound
 | Piedra, [NAME] | PIEDRAR | 0491019.020 | 04:47:48 | R91 | 49N015 | BU1 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 30 | 1st | Inbound
 | Guevara, Jorge | [NAME] | 4000107R.020 | 04:51:26 | R91 | 57N039 | FB1 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 50 | 1st | Inbound
 | council, [NAME] | COUNCILR | 1997100 | 04:54:09 | R85 | 21S052 | BU4 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 30 | 1st | Inbound
 | Guevara, Jorge | [NAME] | 4000107R.020 | 04:54:53 | R91 | 57N039 | FB1 | 05 | [PHONE] | 0001 | 2020-05-01 00:00:00 | 60 | 1st | Inbound
 | Hawkins, Quintis | HAWKINSQ | 707AA101.020 | 16:33:56 | R37 | 75N001 | FB2 | 05 | [PHONE] | 0001 | 2020-05-07 00:00:00 | 8 | 2nd | Outbound
 | Hawkins, Quintis | HAWKINSQ | 707AA101.020 | 16:36:38 | R37 | 75N001 | FB2 | 05 | [PHONE] | 0001 | 2020-05-07 00:00:00 | 8 | 2nd | Outbound
 | Hawkins, Quintis | HAWKINSQ | 707AA101.020 | 16:40:06 | R37 | 75N001 | FB2 | 05 | [PHONE] | 0001 | 2020-05-07 00:00:00 | 8 | 2nd | Outbound
 | Hawkins, Quintis | HAWKINSQ | 707AA101.020 | 16:44:49 | R37 | 75N001 | FB2 | 05 | [PHONE] | 0001 | 2020-05-07 00:00:00 | 8 | 2nd | Outbound
 | Hawkins, Quintis | HAWKINSQ | 707AA101.020 | 16:45:58 | R37 | 75N001 | FB2 | 05 | [PHONE] | 0001 | 2020-05-07 00:00:00 | 8 | 2nd | Outbound
 | Hawkins, Quintis | HAWKINSQ | 707AA101.020 | 16:48:49 | R37 | 75N001 | FB2 | 05 | [PHONE] | 0001 | 2020-05-07 00:00:00 | 8 | 2nd | Outbound
 | Hawkins, Quintis | HAWKINSQ | 707AA101.020 | 16:57:40 | R37 | 75N001 | FB2 | 05 | [PHONE] | 0001 | 2020-05-07 00:00:00 | 8 | 2nd | Outbound
 | Hawkins, Quintis | HAWKINSQ | 707AA101.020 | 17:04:47 | R37 | 75N001 | FB2 | 05 | [PHONE] | 0001 | 2020-05-07 00:00:00 | 8 | 2nd | Outbound
 | Hawkins, Quintis | HAWKINSQ | 707AA101.020 | 17:06:45 | R37 | 75N001 | FB2 | 05 | [PHONE] | 0001 | 2020-05-07 00:00:00 | 8 | 2nd | Outbound
 | Hawkins, Quintis | HAWKINSQ | 707AA101.020 | 17:08:34 | R37 | 75N001 | FB2 | 05 | [PHONE] | 0001 | 2020-05-07 00:00:00 | 8 | 2nd | Outbound
 | Colums A and B are added for index and vlookup needs.