Spreadsheet: 686990d1594904933-vlookup-returns-n-a-conflict-check-report-help
Sheet: Final Table

Item ID | Item Name | Complete Date from Source | Complete Date
 |  |  | 2020-07-01 12:54:16
 |  |  | 2020-07-01 13:56:00
 |  |  | 2020-07-01 14:47:34
 |  |  | 2020-07-01 14:50:32
 |  |  | 2020-07-01 15:00:44
 |  |  | 2020-07-01 15:09:35
 |  |  | 2020-07-01 15:16:02
 |  |  | 2020-07-01 15:56:49
 |  |  | 2020-07-01 17:29:16
 |  |  | 2020-07-01 17:30:38
 |  |  | 2020-07-01 17:51:28
 |  |  | 2020-07-01 18:24:13
 |  |  | 2020-07-01 18:51:54
 |  |  | 2020-07-01 18:53:51
 |  |  | 2020-07-01 19:05:43
 |  |  | 2020-07-01 19:17:39
 |  |  | 2020-07-01 19:50:42
 |  |  | 2020-07-01 19:53:08
 |  |  | 2020-07-01 20:01:12
 |  |  | 2020-07-01 20:02:11
 |  |  | 2020-07-01 20:11:41
 |  |  | 2020-07-01 20:32:52
 |  |  | 2020-07-01 20:57:01
 |  |  | 2020-07-01 20:58:39
 |  |  | 2020-07-01 21:19:58
 |  |  | 2020-07-01 21:54:58
 |  |  | 2020-07-01 21:57:27
 |  |  | 2020-07-01 21:59:34
 |  |  | 2020-07-02 00:23:19
 |  |  | 2020-07-02 00:33:11
 |  |  | 2020-07-02 00:41:10
 |  |  | 2020-07-02 10:14:31
 |  |  | 2020-07-02 12:56:52
 |  |  | 2020-07-02 13:07:13
 |  |  | 2020-07-02 13:16:46
 |  |  | 2020-07-02 13:22:46
 |  |  | 2020-07-02 13:32:44
 |  |  | 2020-07-02 13:37:56
 |  |  | 2020-07-02 15:21:53
 |  |  | 2020-07-02 15:33:55
 |  |  | 2020-07-02 15:35:06
 |  |  | 2020-07-02 16:00:18
 |  |  | 2020-07-02 16:25:09
 |  |  | 2020-07-02 17:09:25
 |  |  | 2020-07-02 17:11:48
 |  |  | 2020-07-02 17:28:19
 |  |  | 2020-07-02 17:29:30
 |  |  | 2020-07-02 17:33:08
 |  |  | 2020-07-02 17:34:39
 |  |  | 2020-07-02 17:34:43
 |  |  | 2020-07-02 17:37:36
 |  |  | 2020-07-02 17:38:25
 |  |  | 2020-07-02 17:55:39
 |  |  | 2020-07-02 18:17:47
 |  |  | 2020-07-02 18:20:29
 |  |  | 2020-07-02 18:21:41
 |  |  | 2020-07-02 19:50:12
 |  |  | 2020-07-02 20:07:02
 |  |  | 2020-07-02 21:50:37
 |  |  | 2020-07-02 21:52:16
 |  |  | 2020-07-02 21:54:14
 |  |  | 2020-07-02 21:55:52
 |  |  | 2020-07-02 21:57:25
 |  |  | 2020-07-02 21:58:50
 |  |  | 2020-07-02 22:00:23
 |  |  | 2020-07-02 22:01:50
 |  |  | 2020-07-03 14:10:16
 |  |  | 2020-07-03 14:11:18
 |  |  | 2020-07-06 12:11:31
 |  |  | 2020-07-06 12:11:56
 |  |  | 2020-07-06 12:39:04
 |  |  | 2020-07-06 12:42:34
 |  |  | 2020-07-06 12:48:09
 |  |  | 2020-07-06 12:54:39
 |  |  | 2020-07-06 13:04:36
 |  |  | 2020-07-09 10:19:46
 |  |  | 2020-07-09 10:20:13
 |  |  | 2020-07-09 10:20:40
 |  |  | 2020-07-06 13:28:45
 |  |  | 2020-07-06 13:33:55
 |  |  | 2020-07-06 13:35:46
 |  |  | 2020-07-06 13:40:37
 |  |  | 2020-07-06 13:49:14
 |  |  | 2020-07-06 13:54:25
 |  |  | 2020-07-06 14:04:00
 |  |  | 2020-07-06 14:25:10
 |  |  | 2020-07-06 15:08:02
 |  |  | 2020-07-06 15:12:04
 |  |  | 2020-07-06 15:19:05
 |  |  | 2020-07-06 15:32:14
 |  |  | 2020-07-06 15:39:27
 |  |  | 2020-07-06 15:46:11
 |  |  | 2020-07-06 15:49:24
 |  |  | 2020-07-06 16:15:16
 |  |  | 2020-07-06 16:16:16
 |  |  | 2020-07-06 16:27:47
 |  |  | 2020-07-06 16:36:21
 |  |  | 2020-07-06 16:53:11
 |  |  | 2020-07-06 16:53:25
 |  |  | 2020-07-06 17:01:05
 |  |  | 2020-07-06 17:43:45
 |  |  | 2020-07-06 17:50:14
 |  |  | 2020-07-06 17:55:00
 |  |  | 2020-07-06 17:58:21
 |  |  | 2020-07-06 18:03:08
 |  |  | 2020-07-06 18:12:01
 |  |  | 2020-07-06 18:16:16
 |  |  | 2020-07-06 18:25:28
 |  |  | 2020-07-06 18:33:14
 |  |  | 2020-07-06 19:07:31
 |  |  | 2020-07-06 19:07:51
 |  |  | 2020-07-06 19:14:59
 |  |  | 2020-07-06 19:16:29
 |  |  | 2020-07-06 19:25:18
 |  |  | 2020-07-06 19:57:23
 |  |  | 2020-07-06 20:17:03
 |  |  | 2020-07-07 10:45:07
 |  |  | 2020-07-07 10:46:42
 |  |  | 2020-07-07 13:09:37
 |  |  | 2020-07-07 13:39:18
 |  |  | 2020-07-07 13:47:14
 |  |  | 2020-07-07 13:48:52
 |  |  | 2020-07-07 13:59:59
 |  |  | 2020-07-07 15:23:14
 |  |  | 2020-07-07 16:00:53
 |  |  | 2020-07-08 12:18:13
 |  |  | 2020-07-08 12:57:49
 |  |  | 2020-07-08 13:45:15
 |  |  | 2020-07-08 13:49:30
 |  |  | 2020-07-08 15:00:14
 |  |  | 2020-07-08 15:36:21
 |  |  | 2020-07-08 17:32:58
 |  |  | 2020-07-08 17:49:59
 |  |  | 2020-07-08 17:51:15
 |  |  | 2020-07-08 18:01:13
 |  |  | 2020-07-08 18:21:13
 |  |  | 2020-07-08 18:21:57
 |  |  | 2020-07-08 18:26:15
 |  |  | 2020-07-08 18:57:18
 |  |  | 2020-07-08 18:59:12
 |  |  | 2020-07-08 18:59:41
 |  |  | 2020-07-08 19:09:12
 |  |  | 2020-07-08 19:16:45
 |  |  | 2020-07-08 19:34:25
 |  |  | 2020-07-08 19:52:07
 |  |  | 2020-07-08 20:22:17
 |  |  | 2020-07-09 12:56:05
 |  |  | 2020-07-09 12:59:37
 |  |  | 2020-07-09 13:38:34
 |  |  | 2020-07-09 14:00:17
 |  |  | 2020-07-09 14:03:17
 |  |  | 2020-07-09 14:22:13
 |  |  | 2020-07-09 14:27:02
 |  |  | 2020-07-09 14:29:04
 |  |  | 2020-07-09 14:29:29
 |  |  | 2020-07-09 14:30:48
 |  |  | 2020-07-09 14:32:21
 |  |  | 2020-07-09 14:32:59
 |  |  | 2020-07-09 14:34:00
 |  |  | 2020-07-09 14:41:33
 |  |  | 2020-07-09 15:39:46
 |  |  | 2020-07-09 15:49:19
 |  |  | 2020-07-09 15:56:50
 |  |  | 2020-07-09 16:01:17
 |  |  | 2020-07-09 16:08:16
 |  |  | 2020-07-09 16:21:04
 |  |  | 2020-07-09 16:31:21
 |  |  | 2020-07-09 16:38:47
 |  |  | 2020-07-09 17:31:56
 |  |  | 2020-07-09 17:34:44
 |  |  | 2020-07-09 17:47:34
 |  |  | 2020-07-09 18:00:02
 |  |  | 2020-07-09 18:28:36
 |  |  | 2020-07-09 18:30:23
 |  |  | 2020-07-09 19:23:42
 |  |  | 2020-07-09 19:36:36
 |  |  | 2020-07-09 20:04:12
 |  |  | 2020-07-09 20:05:39
 |  |  | 2020-07-09 20:06:17
 |  |  | 2020-07-10 01:08:14
 |  |  | 2020-07-10 01:24:44
 |  |  | 2020-07-10 04:08:27
 |  |  | 2020-07-10 04:12:29
 |  |  | 2020-07-10 04:16:07
 |  |  | 2020-07-10 04:19:30
 |  |  | 2020-07-10 12:07:07
 |  |  | 2020-07-10 12:21:24
 |  |  | 2020-07-10 12:39:58
 |  |  | 2020-07-10 13:08:09
 |  |  | 2020-07-10 13:11:21
 |  |  | 2020-07-10 13:23:31
 |  |  | 2020-07-10 13:31:46
 |  |  | 2020-07-10 13:34:54
 |  |  | 2020-07-10 13:48:54
 |  |  | 2020-07-10 13:57:22
 |  |  | 2020-07-10 14:01:07
 |  |  | 2020-07-10 14:20:55
 |  |  | 2020-07-10 14:25:20
 |  |  | 2020-07-10 15:04:02
 |  |  | 2020-07-10 15:19:55
 |  |  | 2020-07-10 16:06:58
 |  |  | 2020-07-10 17:33:31
 |  |  | 2020-07-10 17:51:47
 |  |  | 2020-07-10 18:26:51
 |  |  | 2020-07-10 19:14:06
 |  |  | 2020-07-10 19:15:40
 |  |  | 2020-07-10 19:15:40
 |  |  | 2020-07-10 19:20:11
 |  |  | 2020-07-10 19:21:53
 |  |  | 2020-07-10 19:50:29
 |  |  | 2020-07-10 20:03:59
 |  |  | 2020-07-10 20:25:41
 |  |  | 2020-07-10 23:52:53
 |  |  | 2020-07-12 12:19:18
 |  |  | 2020-07-13 12:16:22
 |  |  | 2020-07-13 14:13:30
 |  |  | 2020-07-13 14:28:24
 |  |  | 2020-07-13 15:01:50
 |  |  | 2020-07-13 17:33:01
 |  |  | 2020-07-13 17:42:44
 |  |  | 2020-07-13 17:59:47
 |  |  | 2020-07-13 18:19:16
 |  |  | 2020-07-13 18:24:42
 |  |  | 2020-07-13 18:34:31
 |  |  | 2020-07-13 18:36:32
 |  |  | 2020-07-13 18:39:32
 |  |  | 2020-07-13 18:40:43
 |  |  | 2020-07-13 18:42:12
 |  |  | 2020-07-13 18:44:19
 |  |  | 2020-07-13 18:45:42
 |  |  | 2020-07-13 18:46:43
 |  |  | 2020-07-13 18:47:07
 |  |  | 2020-07-13 19:15:10
 |  |  | 2020-07-13 19:25:00
 |  |  | 2020-07-13 19:26:17
 |  |  | 2020-07-13 19:28:12
 |  |  | 2020-07-13 19:29:25
 |  |  | 2020-07-13 19:31:07
 |  |  | 2020-07-13 19:32:35
 |  |  | 2020-07-13 19:35:26
 |  |  | 2020-07-13 19:36:30
 |  |  | 2020-07-13 19:37:38
 |  |  | 2020-07-13 19:38:49
 |  |  | 2020-07-13 19:40:49
 |  |  | 2020-07-13 19:42:00
 |  |  | 2020-07-13 19:46:16
 |  |  | 2020-07-13 19:55:14
 |  |  | 2020-07-13 20:03:05
 |  |  | 2020-07-13 20:04:23
 |  |  | 2020-07-13 20:06:33
 |  |  | 2020-07-13 20:09:30
 |  |  | 2020-07-13 20:21:48
 |  |  | 2020-07-13 20:21:53
 |  |  | 2020-07-13 20:26:31
 |  |  | 2020-07-13 21:11:58
 |  |  | 2020-07-13 21:12:31
 |  |  | 2020-07-13 22:08:50
 |  |  | 2020-07-13 22:11:50
 |  |  | 2020-07-13 22:16:29
 |  |  | 2020-07-13 22:18:19
 |  |  | 2020-07-13 22:20:08
 |  |  | 2020-07-13 22:23:33
 |  |  | 2020-07-13 22:28:03
 |  |  | 2020-07-13 22:31:48
 |  |  | 2020-07-13 22:33:09
 |  |  | 2020-07-13 22:35:03
 |  |  | 2020-07-13 22:43:33
 |  |  | 2020-07-13 22:45:21
 |  |  | 2020-07-13 23:00:59
 |  |  | 2020-07-13 23:01:17
 |  |  | 2020-07-13 23:04:06
 |  |  | 2020-07-13 23:06:34
 |  |  | 2020-07-13 23:08:02
 |  |  | 2020-07-13 23:09:04
 |  |  | 2020-07-13 23:09:27
 |  |  | 2020-07-13 23:11:08
 |  |  | 2020-07-13 23:19:04
 |  |  | 2020-07-13 23:21:10
 |  |  | 2020-07-13 23:22:58
 |  |  | 2020-07-13 23:30:27
 |  |  | 2020-07-13 23:33:37
 |  |  | 2020-07-13 23:38:29
 |  |  | 2020-07-13 23:40:55
 |  |  | 2020-07-13 23:47:50
 |  |  | 2020-07-13 23:49:34
 |  |  | 2020-07-14 01:36:54
 |  |  | 2020-07-14 01:38:27
 |  |  | 2020-07-14 06:11:39
 |  |  | 2020-07-14 06:14:09
 |  |  | 2020-07-14 06:16:24
 |  |  | 2020-07-14 06:19:05
 |  |  | 2020-07-14 06:21:58
 |  |  | 2020-07-14 06:27:20
 |  |  | 2020-07-14 06:29:13
 |  |  | 2020-07-14 06:33:56
 |  |  | 2020-07-14 06:36:07
 |  |  | 2020-07-14 06:41:42
 |  |  | 2020-07-14 06:44:15
 |  |  | 2020-07-14 06:53:17
 |  |  | 2020-07-14 06:54:59
 |  |  | 2020-07-14 10:45:51
 |  |  | 2020-07-14 11:02:02
 |  |  | 2020-07-14 11:09:55
 |  |  | 2020-07-14 11:23:44
 |  |  | 2020-07-14 11:47:19
 |  |  | 2020-07-14 12:16:58
 |  |  | 2020-07-14 12:33:54
 |  |  | 2020-07-14 12:41:48
 |  |  | 2020-07-14 12:43:22
 |  |  | 2020-07-14 12:47:32
 |  |  | 2020-07-14 12:50:27
 |  |  | 2020-07-14 13:01:33
 |  |  | 2020-07-14 13:04:23
 |  |  | 2020-07-14 13:50:36
 |  |  | 2020-07-14 13:51:39
 |  |  | 2020-07-14 13:59:11
 |  |  | 2020-07-14 14:07:20
 |  |  | 2020-07-14 14:47:50
 |  |  | 2020-07-14 14:53:25
 |  |  | 2020-07-14 16:09:08
 |  |  | 2020-07-14 16:51:49
 |  |  | 2020-07-14 16:56:57
 |  |  | 2020-07-14 16:58:37
 |  |  | 2020-07-14 16:59:54
 |  |  | 2020-07-14 17:01:13
 |  |  | 2020-07-14 17:02:12
 |  |  | 2020-07-14 17:03:21
 |  |  | 2020-07-14 17:09:13
 |  |  | 2020-07-14 17:50:21
 |  |  | 2020-07-14 18:35:36
 |  |  | 2020-07-14 18:59:39
 |  |  | 2020-07-14 19:00:06
 |  |  | 2020-07-14 19:11:41
 |  |  | 2020-07-14 19:12:31
 |  |  | 2020-07-14 19:13:19
 |  |  | 2020-07-14 19:14:22
 |  |  | 2020-07-14 19:38:25
 |  |  | 2020-07-14 19:51:01
 |  |  | 2020-07-14 20:21:02
 |  |  | 2020-07-14 21:20:46