Spreadsheet: 843923d1695740053-subtract-using-vlookup-or-sumif-within-time-condition-sample-data-1-
Sheet: Sheet1

 |  |  |  |  |  | ['PT-2' - 'PT-3'] if time w/in 5 min | Note: Have 10,000 rows of data and PT-2 column exceeds PT-3 column by several hundred rows so timestamp gap within row becomes greater as time progresses
Time | [NAME] (Lesser) |  | Time | PT-2 (Greater) |  | Difference EXPECTED TO HAVE LESS THAN 20% "ERRORS" IN COLUMN | Expected | VLOOKUP |  | Condition
2023-01-01 07:00:00 | 49.82 |  | 2023-01-01 07:00:00 | 63.57 |  |  | 13.75
2023-01-01 07:06:44.342000 | 97.53 |  | 2023-01-01 08:01:41.056000 | 14.28 |  |  | -
2023-01-01 07:08:47.480000 | 9.66 |  | 2023-01-01 08:53:01.526000 | 104.81 |  |  | -
2023-01-01 09:09:09.676000 | 41.97 |  | 2023-01-01 09:09:23.688000 | 56.25 |  |  | 14.28
2023-01-01 09:09:36.705000 | 43.78 |  | 2023-01-01 09:09:24.689000 | 57 |  |  | 13.22
2023-01-01 09:23:24.652000 | 81.75 |  | 2023-01-01 10:01:59.304000 | 0 |  |  | -0.16
2023-01-01 10:01:41.281000 | 0.16 |  | 2023-01-01 11:07:22.837000 | 88.31 |  |  | -
2023-01-01 11:18:45.621000 | 24.16 |  | 2023-01-01 11:18:46.622000 | 37.5 |  |  | 13.34
2023-01-01 11:19:27.667000 | 24.63 |  | 2023-01-01 11:18:47.623000 | 36.78 |  |  | 12.15
2023-01-01 11:47:16.569000 | 0 |  | 2023-01-01 11:47:17.570000 | 0.16 |  |  | 0.16
2023-01-01 13:23:19.137000 | 85.66 |  | 2023-01-01 13:23:19.137000 | 97.38 |  |  | 11.72
2023-01-01 13:28:09.493000 | 19.5 |  | 2023-01-01 13:28:02.484000 | 32.25 |  |  | 12.75
2023-01-01 13:28:17.504000 | 19.56 |  | 2023-01-01 13:28:12.497000 | 32.19 |  |  | 12.63
2023-01-01 15:09:00.330000 | 95.75 |  | 2023-01-01 15:09:00.330000 | 104.78 |  |  | 9.030000000000001
2023-01-01 15:37:30.374000 | 9.66 |  | 2023-01-01 15:37:30.374000 | 14.31 |  |  | 4.65
2023-01-01 15:37:34.379000 | 26.41 |  | 2023-01-01 15:37:34.379000 | 31.69 |  |  | 5.280000000000001
2023-01-01 15:37:35.380000 | 28.56 |  | 2023-01-01 15:37:35.380000 | 33.88 |  |  | 5.320000000000004
2023-01-01 16:04:03.123000 | 9.69 |  | 2023-01-01 16:30:53 | 14.22 |  |  | -
2023-01-01 17:22:11.984000 | 96.19 |  | 2023-01-01 16:55:39.102000 | 102.34 |  |  | 6.150000000000006
2023-01-04 12:33:00.103000 | 95.91 |  | 2023-01-04 12:38:11.424000 | 32.63 |  |  | -63.27999999999999
2023-01-04 12:35:00.218000 | 10.13 |  | 2023-01-04 12:38:15.429000 | 32.63 |  |  | 22.5
2023-01-04 12:38:12.425000 | 19.59 |  | 2023-01-04 13:27:39.913000 | 14.22 |  |  | -
2023-01-04 12:38:30.447000 | 19.75 |  | 2023-01-04 14:45:29.275000 | 101.81 |  |  | -
2023-01-04 13:52:09.534000 | 92.09 |  | 2023-01-04 14:47:33.417000 | 36.66
2023-01-04 13:54:07.661000 | 9.78 |  | 2023-01-04 14:47:39.426000 | 35.59
2023-01-04 14:47:35.420000 | 30.56 |  | 2023-01-04 15:11:55.155000 | 103.13
2023-01-04 14:47:37.422000 | 29.59 |  | 2023-01-04 16:16:27.631000 | 0.03
2023-01-04 15:11:55.155000 | 97.13 |  | 2023-01-04 16:17:05.670000 | 0.09
2023-01-04 16:16:27.631000 | 0 |  | 2023-01-04 16:58:58.511000 | 0.38 |  |  | -
2023-01-04 16:17:04.670000 | 0.06 |  | 2023-01-04 18:39:55.527000 | 99.47
2023-01-04 17:11:43.453000 | 0.16 |  | 2023-01-04 19:06:21.413000 | 23.75
2023-01-04 17:59:52.782000 | 0 |  | 2023-01-04 19:06:27.422000 | 24
2023-01-04 18:39:55.527000 | 92.56 |  | 2023-01-04 19:30:27.151000 | 104.63
2023-01-04 19:06:21.413000 | 19.63 |  | 2023-01-04 19:59:14.101000 | 14.06
2023-01-04 19:06:27.422000 | 19.66 |  | 2023-01-04 21:15:45.517000 | 69.06
2023-01-04 19:06:31.423000 | 9.63 |  | 2023-01-04 21:15:49.522000 | 69.44
2023-01-04 19:30:27.151000 | 96.47 |  | 2023-01-04 21:18:34.710000 | 14.25
2023-01-04 21:15:37.509000 | 55.53 |  | 2023-01-04 22:09:43.210000 | 102.94
2023-01-04 21:15:49.522000 | 55.53 |  | 2023-01-04 23:25:11.453000 | 48.88