Spreadsheet: 847608d1698458243-look-up-and-return-row-examplereturn-1-
Sheet: IDATA

 |  |  |  |  |  |  |  |  | Is it greater than 50?
2023-10-27 00:00:00 | FRI | 00:00:00 | 2023-10-27 00:00:00 | 14306.5 | 0
2023-10-27 00:00:00 | FRI | 00:07:14 | 2023-10-27 00:07:14 | 14302.5 | -4
2023-10-27 00:00:00 | FRI | 00:59:28 | 2023-10-27 00:59:28 | 14323 | 20.5
2023-10-27 00:00:00 | FRI | 01:01:36 | 2023-10-27 01:01:36 | 14310 | -13
2023-10-27 00:00:00 | FRI | 01:30:23 | 2023-10-27 01:30:23 | 14322.5 | 12.5
2023-10-27 00:00:00 | FRI | 01:41:04 | 2023-10-27 01:41:04 | 14307.75 | -14.75
2023-10-27 00:00:00 | FRI | 01:59:34 | 2023-10-27 01:59:34 | 14325.5 | 17.75
2023-10-27 00:00:00 | FRI | 02:00:01 | 2023-10-27 02:00:01 | 14324.25 | -1.25
2023-10-27 00:00:00 | FRI | 03:05:56 | 2023-10-27 03:05:56 | 14276 | -48.25
2023-10-27 00:00:00 | FRI | 5:00:00 | 2023-10-27 05:00:00 | 14339.5 | 63.5
2023-10-27 00:00:00 | FRI | 05:05:33 | 2023-10-27 05:05:33 | 14343.5 | 4
2023-10-27 00:00:00 | FRI | 05:48:03 | 2023-10-27 05:48:03 | 14314.25 | -29.25
2023-10-27 00:00:00 | FRI | 06:21:09 | 2023-10-27 06:21:09 | 14340 | 25.75
2023-10-27 00:00:00 | FRI | 06:38:54 | 2023-10-27 06:38:54 | 14316 | -24
2023-10-27 00:00:00 | FRI | 06:48:31 | 2023-10-27 06:48:31 | 14333 | 17
2023-10-27 00:00:00 | FRI | 07:00:00 | 2023-10-27 07:00:00 | 14312.5 | -20.5
2023-10-27 00:00:00 | FRI | 07:27:30 | 2023-10-27 07:27:30 | 14288 | -24.5
2023-10-27 00:00:00 | FRI | 07:34:41 | 2023-10-27 07:34:41 | 14306.25 | 18.25
2023-10-27 00:00:00 | FRI | 07:36:44 | 2023-10-27 07:36:44 | 14289 | -17.25
2023-10-27 00:00:00 | FRI | 07:46:28 | 2023-10-27 07:46:28 | 14303 | 14
2023-10-27 00:00:00 | FRI | 08:00:00 | 2023-10-27 08:00:00 | 14281 | -22
2023-10-27 00:00:00 | FRI | 08:03:28 | 2023-10-27 08:03:28 | 14270 | -11
2023-10-27 00:00:00 | FRI | 08:16:28 | 2023-10-27 08:16:28 | 14304.25 | 34.25
2023-10-27 00:00:00 | FRI | 08:22:13 | 2023-10-27 08:22:13 | 14293 | -11.25
2023-10-27 00:00:00 | FRI | 08:30:00 | 2023-10-27 08:30:00 | 14298.75 | 5.75
2023-10-27 00:00:00 | FRI | 08:30:01 | 2023-10-27 08:30:01 | 14297.75 | -1
2023-10-27 00:00:00 | FRI | 08:30:09 | 2023-10-27 08:30:09 | 14277 | -20.75
2023-10-27 00:00:00 | FRI | 08:35:05 | 2023-10-27 08:35:05 | 14321.75 | 44.75
2023-10-27 00:00:00 | FRI | 08:42:05 | 2023-10-27 08:42:05 | 14284.75 | -37
2023-10-27 00:00:00 | FRI | 08:56:31 | 2023-10-27 08:56:31 | 14334.5 | 49.75
2023-10-27 00:00:00 | FRI | 08:58:05 | 2023-10-27 08:58:05 | 14308.75 | -25.75
2023-10-27 00:00:00 | FRI | 09:00:00 | 2023-10-27 09:00:00 | 14313.5 | 4.75
2023-10-27 00:00:00 | FRI | 09:03:52 | 2023-10-27 09:03:52 | 14331 | 17.5
2023-10-27 00:00:00 | FRI | 09:19:45 | 2023-10-27 09:19:45 | 14306.5 | -24.5
2023-10-27 00:00:00 | FRI | 09:24:00 | 2023-10-27 09:24:00 | 14319.5 | 13
2023-10-27 00:00:00 | FRI | 09:27:41 | 2023-10-27 09:27:41 | 14299.5 | -20
2023-10-27 00:00:00 | FRI | 09:30:00 | 2023-10-27 09:30:00 | 14306.25 | 6.75
2023-10-27 00:00:00 | FRI | 09:30:01 | 2023-10-27 09:30:01 | 14306 | -0.25
2023-10-27 00:00:00 | FRI | 09:33:34 | 2023-10-27 09:33:34 | 14349.25 | 43.25
2023-10-27 00:00:00 | FRI | 09:36:19 | 2023-10-27 09:36:19 | 14308 | -41.25
2023-10-27 00:00:00 | FRI | 09:39:01 | 2023-10-27 09:39:01 | 14341.25 | 33.25
2023-10-27 00:00:00 | FRI | 09:40:18 | 2023-10-27 09:40:18 | 14302 | -39.25
2023-10-27 00:00:00 | FRI | 09:45:28 | 2023-10-27 09:45:28 | 14357 | 55
2023-10-27 00:00:00 | FRI | 09:49:25 | 2023-10-27 09:49:25 | 14292 | -65
2023-10-27 00:00:00 | FRI | 09:52:36 | 2023-10-27 09:52:36 | 14324.75 | 32.75
2023-10-27 00:00:00 | FRI | 09:55:01 | 2023-10-27 09:55:01 | 14291 | -33.75
2023-10-27 00:00:00 | FRI | 09:58:12 | 2023-10-27 09:58:12 | 14331.75 | 40.75
2023-10-27 00:00:00 | FRI | 10:00:00 | 2023-10-27 10:00:00 | 14327.25 | -4.5
2023-10-27 00:00:00 | FRI | 10:00:01 | 2023-10-27 10:00:01 | 14327.5 | 0.25
2023-10-27 00:00:00 | FRI | 10:02:29 | 2023-10-27 10:02:29 | 14293.75 | -33.75
2023-10-27 00:00:00 | FRI | 10:07:20 | 2023-10-27 10:07:20 | 14358.25 | 64.5
2023-10-27 00:00:00 | FRI | 10:09:36 | 2023-10-27 10:09:36 | 14293.75 | -64.5
2023-10-27 00:00:00 | FRI | 10:14:15 | 2023-10-27 10:14:15 | 14369.5 | 75.75
2023-10-27 00:00:00 | FRI | 10:19:33 | 2023-10-27 10:19:33 | 14308.5 | -61
2023-10-27 00:00:00 | FRI | 10:26:35 | 2023-10-27 10:26:35 | 14359 | 50.5
2023-10-27 00:00:00 | FRI | 10:33:57 | 2023-10-27 10:33:57 | 14311.25 | -47.75
2023-10-27 00:00:00 | FRI | 10:36:39 | 2023-10-27 10:36:39 | 14351.75 | 40.5
2023-10-27 00:00:00 | FRI | 10:42:37 | 2023-10-27 10:42:37 | 14274 | -77.75
2023-10-27 00:00:00 | FRI | 11:00:00 | 2023-10-27 11:00:00 | 14336.75 | 62.75
2023-10-27 00:00:00 | FRI | 11:17:15 | 2023-10-27 11:17:15 | 14404.75 | 68
2023-10-27 00:00:00 | FRI | 11:20:28 | 2023-10-27 11:20:28 | 14377.5 | -27.25
2023-10-27 00:00:00 | FRI | 11:22:55 | 2023-10-27 11:22:55 | 14407.75 | 30.25
2023-10-27 00:00:00 | FRI | 11:34:25 | 2023-10-27 11:34:25 | 14351.25 | -56.5
2023-10-27 00:00:00 | FRI | 11:37:25 | 2023-10-27 11:37:25 | 14382 | 30.75
2023-10-27 00:00:00 | FRI | 11:45:24 | 2023-10-27 11:45:24 | 14337.5 | -44.5
2023-10-27 00:00:00 | FRI | 12:00:00 | 2023-10-27 12:00:00 | 14373 | 35.5
2023-10-27 00:00:00 | FRI | 12:02:00 | 2023-10-27 12:02:00 | 14382.75 | 9.75
2023-10-27 00:00:00 | FRI | 12:04:37 | 2023-10-27 12:04:37 | 14352.25 | -30.5
2023-10-27 00:00:00 | FRI | 12:06:21 | 2023-10-27 12:06:21 | 14385 | 32.75
2023-10-27 00:00:00 | FRI | 12:15:13 | 2023-10-27 12:15:13 | 14344 | -41
2023-10-27 00:00:00 | FRI | 12:20:17 | 2023-10-27 12:20:17 | 14372.5 | 28.5
2023-10-27 00:00:00 | FRI | 12:27:34 | 2023-10-27 12:27:34 | 14314 | -58.5
2023-10-27 00:00:00 | FRI | 12:37:39 | 2023-10-27 12:37:39 | 14355.75 | 41.75
2023-10-27 00:00:00 | FRI | 13:00:00 | 2023-10-27 13:00:00 | 14304 | -51.75
2023-10-27 00:00:00 | FRI | 13:18:33 | 2023-10-27 13:18:33 | 14236.75 | -67.25
2023-10-27 00:00:00 | FRI | 13:26:59 | 2023-10-27 13:26:59 | 14280.25 | 43.5
2023-10-27 00:00:00 | FRI | 13:30:00 | 2023-10-27 13:30:00 | 14257.25 | -23
2023-10-27 00:00:00 | FRI | 13:30:54 | 2023-10-27 13:30:54 | 14238.25 | -19
2023-10-27 00:00:00 | FRI | 13:35:17 | 2023-10-27 13:35:17 | 14271.5 | 33.25
2023-10-27 00:00:00 | FRI | 13:40:25 | 2023-10-27 13:40:25 | 14239 | -32.5
2023-10-27 00:00:00 | FRI | 13:44:02 | 2023-10-27 13:44:02 | 14277.5 | 38.5
2023-10-27 00:00:00 | FRI | 14:00:00 | 2023-10-27 14:00:00 | 14243 | -34.5
2023-10-27 00:00:00 | FRI | 14:06:39 | 2023-10-27 14:06:39 | 14212.25 | -30.75
2023-10-27 00:00:00 | FRI | 14:17:03 | 2023-10-27 14:17:03 | 14267.5 | 55.25
2023-10-27 00:00:00 | FRI | 14:24:36 | 2023-10-27 14:24:36 | 14215.75 | -51.75
2023-10-27 00:00:00 | FRI | 14:45:33 | 2023-10-27 14:45:33 | 14284.75 | 69
2023-10-27 00:00:00 | FRI | 14:58:45 | 2023-10-27 14:58:45 | 14214 | -70.75
2023-10-27 00:00:00 | FRI | 15:00:00 | 2023-10-27 15:00:00 | 14226 | 12
2023-10-27 00:00:00 | FRI | 15:30:35 | 2023-10-27 15:30:35 | 14267.75 | 41.75
2023-10-27 00:00:00 | FRI | 15:40:15 | 2023-10-27 15:40:15 | 14209.75 | -58
2023-10-27 00:00:00 | FRI | 16:00:00 | 2023-10-27 16:00:00 | 14265.75 | 56
2023-10-27 00:00:00 | FRI | 16:01:24 | 2023-10-27 16:01:24 | 14283.5 | 17.75
2023-10-27 00:00:00 | FRI | 16:13:32 | 2023-10-27 16:13:32 | 14265 | -18.5
2023-10-27 00:00:00 | FRI | 16:30:00 | 2023-10-27 16:30:00 | 14270 | 5
2023-10-27 00:00:00 | FRI | 16:40:20 | 2023-10-27 16:40:20 | 14277.75 | 7.75
2023-10-27 00:00:00 | FRI | 17:00:00 | 2023-10-27 17:00:00 | 14270 | -7.75