Spreadsheet: 116119d1311612754-finding-first-value-that-is-greater-than-value-lookup-example
Sheet: summary

 | Key |  | Handshake Date # | Pip | Q1 | Pip 1 | Pip 1 date | Question 1 | Question 1 date | 1st sold script (qualify for handshake) | 24 days after handshake block (col. C) | 120 days after col. E or I
Record # |  | Handshake?
194032883 | blocked OK | 2011-01-18 11:29:34 | 40561.47886574074 |  |  | 3357 | 2011-02-09 17:11:57 | 3364 | 2011-02-09 17:19:53 | 2011-01-18 00:00:00
339701802230 | blocked OK | 2011-01-19 16:30:23 | 40562.6877662037 |  |  | 3358 | 2011-02-11 13:05:27 | 3365 | 2011-02-11 17:14:25
5045054036 | blocked OK | 2011-01-20 15:37:01 | 40563.65070601852 |  |  | 3358 | 2011-02-15 17:23:27 | 3365 | 2011-02-19 09:02:38
5825014106 | blocked OK | 2011-01-20 12:50:41 | 40563.53519675926 |  |  | 3358 | 2011-02-17 13:14:49 | 3365 | 2011-02-18 12:13:16
5503057643 | blocked OK | 2011-01-27 15:21:36 | 40570.64 |  |  | 3358 | 2011-02-19 20:47:56 | 3365 | 2011-02-20 15:00:05
11386056796 | blocked OK | 2011-01-19 11:26:30 | 40562.47673611111 |  |  | 3360 | 2011-02-22 08:24:33 | 3367 | 2011-02-22 11:59:05
6564021016 | blocked OK | 2011-01-28 16:00:56 | 40571.66731481482 |  |  | 3358 | 2011-02-22 13:12:48 | 3365 | 2011-03-17 16:24:10
4542102683 | blocked OK | 2011-01-24 16:21:30 | 40567.68159722222 |  |  | 3359 | 2011-02-23 09:38:48 | 3366 | 2011-02-23 09:48:55
11386063093 | blocked OK | 2011-01-20 12:10:11 | 40563.50707175926 |  |  | 3359 | 2011-02-23 09:46:32 | 3366 | 2011-02-23 11:49:47
680016177 | blocked OK | 2011-01-22 10:56:43 | 40565.45605324074 |  |  | 3361 | 2011-02-23 18:37:14 | 3368 | 2011-02-23 19:04:50
339701701317 | blocked OK | 2011-01-26 15:04:49 | 40569.62834490741 |  |  | 3360 | 2011-02-24 15:19:51 | 3367 | 2011-02-25 12:16:18
1525037144 | blocked OK | 2011-01-29 00:30:25 | 40572.02112268518 |  |  | 3358 | 2011-02-25 18:56:25 | 3365 | 2011-03-20 19:14:06
189011195 | blocked OK | 2011-01-29 14:16:46 | 40572.59497685185 |  |  | 3358 | 2011-02-27 21:31:14 | 3365 | 2011-02-28 21:56:26
4349123257 | blocked OK | 2011-01-26 09:44:48 | 40569.40611111111 |  |  | 3360 | 2011-03-01 11:31:24
5258051010 | blocked OK | 2011-02-04 16:38:11 | 40578.69318287037 |  |  | 3359 | 2011-03-01 18:16:11 | 3366 | 2011-03-18 17:13:20
4542090856 | blocked OK | 2011-01-24 11:12:16 | 40567.46685185185 |  |  | 3358 | 2011-03-01 20:05:53 | 3365 | 2011-03-02 11:03:37
211179792 | blocked OK | 2011-01-28 10:07:21 | 40571.42177083333 |  |  | 3358 | 2011-03-01 23:02:56 | 3365 | 2011-03-02 01:08:37
11386050580 | blocked OK | 2011-01-25 07:08:12 | 40568.29736111111 |  |  | 3361 | 2011-03-02 07:33:14 | 3368 | 2011-03-02 07:38:45
5124037511 | blocked OK | 2011-02-01 17:54:18 | 40575.74604166667 |  |  | 3359 | 2011-03-02 09:35:45 | 3366 | 2011-04-12 15:07:14
4664065752 | blocked OK | 2011-01-25 14:34:05 | 40568.60700231481 |  |  | 3358 | 2011-03-02 11:00:37 | 3365 | 2011-03-02 14:30:46
5282067810 | blocked OK | 2011-01-28 13:38:32 | 40571.56842592593 |  |  | 3357 | 2011-03-03 08:11:25 | 3364 | 2011-03-03 14:58:35
6580131757 | blocked OK | 2011-02-05 13:37:20 | 40579.56759259259 |  |  | 3357 | 2011-03-07 04:06:16 | 3364 | 2011-04-13 11:30:57
11386052516 | blocked OK | 2011-01-26 08:07:43 | 40569.33869212963 |  |  | 3358 | 2011-03-07 12:27:31 | 3365 | 2011-03-08 16:23:41
1249249383 | blocked OK | 2011-02-04 18:21:53 | 40578.76519675926 |  |  | 3358 | 2011-03-07 14:12:12 | 3365 | 2011-03-07 18:07:52
5033066350 | blocked OK | 2011-02-05 19:54:34 | 40579.82956018519 |  |  | 3362 | 2011-03-07 17:28:19 | 3369 | 2011-03-07 17:31:28
162149051 | blocked OK | 2011-02-04 18:36:10 | 40578.77511574074 |  |  | 3359 | 2011-03-07 17:30:31 | 3366 | 2011-03-08 14:50:00
2054003385 | blocked OK | 2011-01-26 15:47:37 | 40569.65806712963 |  |  | 3359 | 2011-03-08 17:31:41 | 3366 | 2011-03-09 13:54:41
4306058756 | blocked OK | 2011-02-10 15:08:45 | 40584.63107638889 |  |  | 3358 | 2011-03-08 17:32:12 | 3365 | 2011-03-09 08:16:55
5787002275 | blocked OK | 2011-01-26 15:47:52 | 40569.65824074074 |  |  | 3361 | 2011-03-08 17:52:52 | 3368 | 2011-03-17 15:49:31
211071785 | blocked OK | 2011-02-04 17:43:45 | 40578.73871527778 |  |  | 3357 | 2011-03-09 18:05:30 | 3364 | 2011-03-10 08:53:48
1627128022 | blocked OK | 2011-02-08 12:42:09 | 40582.52927083334 |  |  | 3360 | 2011-03-10 14:58:28 | 3367 | 2011-03-11 12:26:22
3539204059 | blocked OK | 2011-01-28 14:32:32 | 40571.60592592593 |  |  | 3358 | 2011-03-10 17:17:39 | 3365 | 2011-03-14 14:08:32