Spreadsheet: 682977d1592413153-tweaking-vlookups-approximate-match-by-using-variable-xlf-eh-file
Sheet: Sheet1

Array 1 |  |  |  | [NAME]
Time | Price | Type |  | Time | Price | Type |  |  |  | Tolerance
 |  | [NAME]: |  |  |  |  |  |  |  | 60
2020-05-12 23:58:42 | 0.91106 |  | red cells are errors.There should be no "buy" or "sell" cells in Col C. | 2020-06-08 01:00:00 | 0.93543 | close
2020-05-12 23:57:14 | 0.91112 |  |  | 2020-06-08 01:00:00 | 0.93546 | close
2020-05-12 23:59:07 | 0.91119 |  |  | 2020-06-08 01:00:00 | 0.93566 | close
2020-05-14 01:26:16 | 0.90912 |  |  | 2020-06-08 00:26:00 | 0.93487 | buy
2020-05-14 01:25:55 | 0.90932 |  |  | 2020-06-08 00:17:00 | 0.93528 | buy
2020-05-15 09:30:41 | 0.90616 |  |  | 2020-06-08 00:15:00 | 0.93534 | buy
2020-05-15 05:26:38 | 0.90644 |  |  | 2020-06-05 22:59:00 | 0.93642 | close
2020-05-18 23:32:39 | 0.90976 |  |  | 2020-06-05 22:29:00 | 0.9361 | close
2020-05-18 23:02:44 | 0.90952 |  |  | 2020-06-05 22:25:00 | 0.93602 | close
2020-05-21 00:26:44 | 0.91705 |  |  | 2020-06-05 22:18:00 | 0.93567 | buy
2020-05-21 00:28:09 | 0.91699 |  |  | 2020-06-05 22:06:00 | 0.93581 | buy
2020-05-25 00:01:25 | 0.91464 |  | In Array 2 there are no "closes" on 5/25 or 5/24 within 1 hour of 0:01 | 2020-06-05 22:05:00 | 0.93585 | buy
2020-05-25 00:01:44 | 0.91466 |  |  | 2020-06-05 01:03:00 | 0.93734 | close
2020-05-25 00:01:25 | 0.91464 |  |  | 2020-06-05 00:59:00 | 0.93692 | close
2020-05-25 23:54:32 | 0.91549 |  |  | 2020-06-05 00:59:00 | 0.93699 | close
2020-05-26 22:34:43 | 0.91756 |  |  | 2020-06-05 00:26:00 | 0.93658 | buy
2020-05-26 22:34:44 | 0.9178 |  |  | 2020-06-05 00:18:00 | 0.93663 | buy
2020-05-29 00:45:02 | 0.91263 |  |  | 2020-06-05 00:14:00 | 0.93709 | close
2020-05-29 00:46:44 | 0.91207 |  |  | 2020-06-05 00:10:00 | 0.93671 | buy
2020-06-01 22:41:29 | 0.92211 |  |  | 2020-06-05 00:09:00 | 0.93675 | buy
2020-06-01 22:42:06 | 0.92214 |  |  | 2020-06-04 23:53:00 | 0.93719 | close
2020-06-04 23:21:45 | 0.93719 |  |  | 2020-06-04 23:40:00 | 0.93791 | sell
2020-06-04 23:16:26 | 0.93716 |  |  | 2020-06-04 23:25:00 | 0.93739 | close
2020-06-05 22:20:43 | 0.9356 |  |  | 2020-06-04 22:50:00 | 0.93668 | buy
2020-06-05 22:30:33 | 0.93627 |  |  | 2020-06-04 01:54:00 | 0.93463 | close
 |  |  |  | 2020-06-04 01:54:00 | 0.9347 | close
 |  |  |  | 2020-06-04 01:54:00 | 0.93478 | close
 |  |  |  | 2020-06-03 23:31:00 | 0.93442 | buy
 |  |  |  | 2020-06-03 23:21:00 | 0.93448 | buy
 |  |  |  | 2020-06-03 23:20:00 | 0.93458 | buy
 |  |  |  | 2020-06-02 01:18:00 | 0.92303 | close
 |  |  |  | 2020-06-02 00:44:00 | 0.92283 | close
 |  |  |  | 2020-06-02 00:05:00 | 0.92333 | sell
 |  |  |  | 2020-06-02 00:04:00 | 0.92309 | close
 |  |  |  | 2020-06-02 00:04:00 | 0.92309 | sell
 |  |  |  | 2020-06-01 23:31:00 | 0.9227 | close
 |  |  |  | 2020-06-01 23:16:00 | 0.92259 | close
 |  |  |  | 2020-06-01 23:08:00 | 0.92232 | buy
 |  |  |  | 2020-06-01 22:41:00 | 0.92235 | buy
 |  |  |  | 2020-06-01 22:39:00 | 0.92239 | buy
 |  |  |  | 2020-06-01 00:41:00 | 0.9179 | close
 |  |  |  | 2020-06-01 00:37:00 | 0.91737 | close
 |  |  |  | 2020-06-01 00:37:00 | 0.91737 | close
 |  |  |  | 2020-06-01 00:27:00 | 0.91684 | buy
 |  |  |  | 2020-06-01 00:22:00 | 0.91713 | buy
 |  |  |  | 2020-06-01 00:15:00 | 0.91763 | close
 |  |  |  | 2020-06-01 00:10:00 | 0.91722 | buy
 |  |  |  | 2020-06-01 00:07:00 | 0.91726 | buy
 |  |  |  | 2020-05-29 00:46:00 | 0.91216 | s/l
 |  |  |  | 2020-05-29 00:46:00 | 0.91188 | s/l
 |  |  |  | 2020-05-29 00:46:00 | 0.91159 | close
 |  |  |  | 2020-05-28 23:31:00 | 0.91457 | buy
 |  |  |  | 2020-05-28 22:19:00 | 0.9158 | buy
 |  |  |  | 2020-05-28 22:18:00 | 0.91608 | buy
 |  |  |  | 2020-05-28 01:56:00 | 0.91032 | close
 |  |  |  | 2020-05-28 01:00:00 | 0.91027 | close
 |  |  |  | 2020-05-28 00:56:00 | 0.90988 | buy
 |  |  |  | 2020-05-28 00:55:00 | 0.90993 | buy
 |  |  |  | 2020-05-28 00:12:00 | 0.91028 | close
 |  |  |  | 2020-05-28 00:07:00 | 0.91059 | close
 |  |  |  | 2020-05-28 00:05:00 | 0.91069 | close
 |  |  |  | 2020-05-27 23:56:00 | 0.91113 | sell
 |  |  |  | 2020-05-27 23:40:00 | 0.91089 | sell
 |  |  |  | 2020-05-27 23:39:00 | 0.91083 | sell
 |  |  |  | 2020-05-27 04:19:00 | 0.91665 | close
 |  |  |  | 2020-05-27 04:16:00 | 0.91659 | close
 |  |  |  | 2020-05-26 23:57:00 | 0.91699 | buy
 |  |  |  | 2020-05-26 23:55:00 | 0.91704 | buy
 |  |  |  | 2020-05-26 22:34:00 | 0.9179 | close
 |  |  |  | 2020-05-26 22:34:00 | 0.91763 | close
 |  |  |  | 2020-05-26 22:24:00 | 0.91837 | sell
 |  |  |  | 2020-05-26 22:23:00 | 0.91816 | sell
 |  |  |  | 2020-05-26 03:00:00 | 0.91509 | close
 |  |  |  | 2020-05-25 23:40:00 | 0.91493 | buy
 |  |  |  | 2020-05-21 23:16:00 | 0.91602 | close
 |  |  |  | 2020-05-21 22:15:00 | 0.91632 | sell
 |  |  |  | 2020-05-21 00:38:00 | 0.91693 | close
 |  |  |  | 2020-05-21 00:04:00 | 0.91693 | close
 |  |  |  | 2020-05-20 23:38:00 | 0.91744 | sell
 |  |  |  | 2020-05-20 23:15:00 | 0.91736 | sell
 |  |  |  | 2020-05-20 02:21:00 | 0.9115 | close
 |  |  |  | 2020-05-20 02:20:00 | 0.91142 | close
 |  |  |  | 2020-05-20 02:19:00 | 0.91135 | close
 |  |  |  | 2020-05-19 22:41:00 | 0.91145 | buy
 |  |  |  | 2020-05-19 22:31:00 | 0.91151 | buy
 |  |  |  | 2020-05-19 22:30:00 | 0.9116 | buy
 |  |  |  | 2020-05-19 03:01:00 | 0.90953 | close
 |  |  |  | 2020-05-19 03:00:00 | 0.90932 | close
 |  |  |  | 2020-05-19 00:36:00 | 0.90873 | buy
 |  |  |  | 2020-05-19 00:21:00 | 0.90932 | buy
 |  |  |  | 2020-05-18 23:49:00 | 0.90983 | close
 |  |  |  | 2020-05-18 23:02:00 | 0.90973 | close
 |  |  |  | 2020-05-18 22:49:00 | 0.91013 | sell
 |  |  |  | 2020-05-18 22:30:00 | 0.91003 | sell
 |  |  |  | 2020-05-18 01:11:00 | 0.90538 | close
 |  |  |  | 2020-05-18 00:41:00 | 0.90464 | buy
 |  |  |  | 2020-05-15 09:30:00 | 0.90638 | close
 |  |  |  | 2020-05-15 04:15:00 | 0.90732 | close
 |  |  |  | 2020-05-15 03:13:00 | 0.90894 | close
 |  |  |  | 2020-05-14 23:31:00 | 0.90693 | sell
 |  |  |  | 2020-05-14 22:13:00 | 0.90598 | sell
 |  |  |  | 2020-05-14 22:12:00 | 0.90573 | sell
 |  |  |  | 2020-05-14 01:26:00 | 0.90933 | close
 |  |  |  | 2020-05-14 01:26:00 | 0.90931 | close
 |  |  |  | 2020-05-13 23:20:00 | 0.90962 | sell
 |  |  |  | 2020-05-13 23:06:00 | 0.90958 | sell
 |  |  |  | 2020-05-13 01:50:00 | 0.91116 | close
 |  |  |  | 2020-05-13 01:21:00 | 0.91106 | close
 |  |  |  | 2020-05-13 00:50:00 | 0.91147 | sell
 |  |  |  | 2020-05-13 00:49:00 | 0.91137 | sell
 |  |  |  | 2020-05-13 00:48:00 | 0.91123 | close
 |  |  |  | 2020-05-13 00:22:00 | 0.91129 | close
 |  |  |  | 2020-05-13 00:22:00 | 0.91129 | close
 |  |  |  | 2020-05-12 22:40:00 | 0.91099 | buy
 |  |  |  | 2020-05-12 22:22:00 | 0.91103 | buy
 |  |  |  | 2020-05-12 22:21:00 | 0.91108 | buy