Spreadsheet: 866270d1713227358-need-help-with-two-formulas-in-one-table-reference-formula-to-ehf-4-15-2024
Sheet: HBNC Chron Order

Table 1 |  |  |  |  |  |  |  |  |  |  |  |  | Table 2 |  |  |  |  | [NAME] needed ==>> | 1 |  |  | 2
Ticker | Date | Open | High | Low | Close | AdjustedOpen | AdjustedHigh | AdjustedLow | AdjustedClose | Volume | [NAME] |  | Ticker | Ex-Dividend Date | Buy Date |  |  | Buy Price | [NAME] To Recover | [NAME] | Stop Loss Price | Date IF Stop Loss Triggerred | Time Out Date | Avg Price On Time Out Date | Sell Date | Sell Price |  |  | Manual Check Avg High-Low Days To Recover | Manual Check Avg High-Low Recover Date
HBNC | 2020-12-31 00:00:00 | 15.88 | 16.49 | 15.296 | 15.86 | 13.9348501891551 | 14.4701309583859 | 13.422384665826 | 13.9173 | 196388 |  |  |  |  |  |  |  |  |  |  | -0.13 |  | 9
HBNC | 2021-01-04 00:00:00 | 16.03 | 16.12 | 15.22 | 15.43 | 14.0665068049255 | 14.1454828256643 | 13.3557226182761 | 13.54 | 153112
HBNC | 2021-01-05 00:00:00 | 15.4 | 15.7823 | 15.39 | 15.56 | 13.5136979434447 | 13.8491711073265 | 13.50492281491 | 13.6541 | 111927 |  |  | HBNC | 2021-01-07 00:00:00 |  |  | ** |  |  |  |  |  |  |  |  |  |  |  | 1 | 2021-01-07 00:00:00
HBNC | 2021-01-06 00:00:00 | 15.94 | 17.2 | 15.91 | 16.84 | 13.9875393111639 | 15.0932042755344 | 13.9612139548694 | 14.7773 | 173923 |  |  | JPM | 2021-01-05 00:00:00 |  |  | *** |  |  |  |  |  |  |  |  |  |  |  | 2 | 2021-01-06 00:00:00
HBNC | 2021-01-07 00:00:00 | 16.86 | 16.8899 | 16.48 | 16.73 | 14.9009949790795 | 14.9274208242678 | 14.5651481171548 | 14.7861 | 121697
HBNC | 2021-01-08 00:00:00 | 16.49 | 16.49 | 15.9 | 16.28 | 14.5739997542998 | 14.5739997542998 | 14.0525528255528 | 14.3884 | 113562
HBNC | 2021-01-11 00:00:00 | 16.01 | 16.67 | 16.01 | 16.62 | 14.1497767148014 | 14.733090433213 | 14.1497767148014 | 14.6889 | 135863 |  |  | I need help with the two [NAME] in columns T and W:
HBNC | 2021-01-12 00:00:00 | 16.69 | 17.14 | 16.617 | 16.95 | 14.7508090855457 | 15.1485241297935 | 14.6862908672566 | 14.9806 | 115412
HBNC | 2021-01-13 00:00:00 | 16.83 | 16.9 | 16.4878 | 16.72 | 14.8745190789474 | 14.9363857655502 | 14.5720793624402 | 14.7773 | 95357 |  |  | Formula 1 in column T:
HBNC | 2021-01-14 00:00:00 | 16.95 | 17 | 16.83 | 16.97 | 14.9805238656453 | 15.0247142015321 | 14.8744670595168 | 14.9982 | 115392 |  |  | ** | the formula in cell T5 produces the correct number - "1" - even though it does not perform a lookup of the Ticker symbol
HBNC | 2021-01-15 00:00:00 | 16.81 | 16.93 | 16.568 | 16.85 | 14.8568475964392 | 14.9629048071217 | 14.6429655548961 | 14.8922 | 94211 |  |  |  | and thus would fail when applied to a larger sheet, As shown in column AD, the Avg High-Low Days To Recover in row 6 should be "2"
HBNC | 2021-01-19 00:00:00 | 16.91 | 17.07 | 16.845 | 16.96 | 14.9452095518868 | 15.0866189858491 | 14.8877619693396 | 14.9894 | 149939 |  |  |  | I need for the formula to first identify the ticker symbol and then to perform the Days To Recover calculation on the [NAME] that apply to that ticker
HBNC | 2021-01-20 00:00:00 | 16.95 | 17.2 | 16.87 | 17.07 | 14.9805430579965 | 15.2014950205038 | 14.9098384299941 | 15.0866 | 101469
HBNC | 2021-01-21 00:00:00 | 17.07 | 17.09 | 16.71 | 16.8 | 15.0866285714286 | 15.1043047619048 | 14.7684571428571 | 14.848 | 97382 |  |  | *** | the Ticker symbol search must be added to the formula in order for the formula to work in column T and produce the correct number "2"
HBNC | 2021-01-22 00:00:00 | 16.61 | 17.37 | 16.57 | 17.35 | 14.6800807492795 | 15.3517761959654 | 14.6447283573487 | 15.3341 | 183805 |  |  |  | as shown in column AD - "Manual Check." Also, as shown in column AE, the Recover Date in row 6 should be 1/6/21
JPM | 2021-01-04 00:00:00 | 127.5 | 127.8579 | 124.78 | 125.87 | 115.6882954635735 | 116.0130393141336 | 113.2202784936839 | 114.2093 | 16819920
JPM | 2021-01-05 00:00:00 | 124.99 | 126.2995 | 123.77 | 125.65 | 114.2275303859928 | 115.4242737337843 | 113.1125804934341 | 114.8307 | 13731210
JPM | 2021-01-06 00:00:00 | 129.88 | 132.77 | 127.88 | 131.55 | 118.6964977270999 | 121.337650163436 | 116.8687105739263 | 120.2227 | 24909061 |  |  | [NAME] in column W:
JPM | 2021-01-07 00:00:00 | 135.69 | 138.19 | 134.92 | 135.87 | 124.0061991830426 | 126.2909327518952 | 123.302501243836 | 124.1707 | 21940391 |  |  |  | IF the the Average Price in column L falls <= Stop Loss Price in column V within the # of Days specified in cell [NAME], then record the date here
JPM | 2021-01-08 00:00:00 | 135.97 | 136.35 | 134.12 | 136.02 | 124.2621053227466 | 124.6093848698721 | 122.5714022643729 | 124.3078 | 12035130 |  |  |  | IF the the Average Price in column L never falls <= Stop Loss Price in column V within the # of days specified in cell [NAME], then record "NA"
JPM | 2021-01-11 00:00:00 | 134.58 | 138.2 | 134.11 | 138.05 | 122.9917894965592 | 126.3000840275262 | 122.5622595436436 | 126.163 | 15949050
JPM | 2021-01-12 00:00:00 | 139.44 | 141.6599 | 138.8301 | 140.22 | 127.4333627727856 | 129.4621157993153 | 126.8759788947368 | 128.1462 | 18033461
JPM | 2021-01-13 00:00:00 | 138.59 | 140.79 | 138.1 | 140.35 | 126.6565468471678 | 128.667113288208 | 126.2087388671179 | 128.265 | 14816760
JPM | 2021-01-14 00:00:00 | 140.49 | 142.75 | 140 | 141.17 | 128.3929521569739 | 130.458352341149 | 127.9451441524403 | 129.0144 | 18565600
JPM | 2021-01-15 00:00:00 | 137.43 | 141.65 | 137.01 | 138.64 | 125.5963888199654 | 129.4530195470283 | 125.2125535343335 | 126.7022 | 27881020
JPM | 2021-01-19 00:00:00 | 139.86 | 140.7 | 137.82 | 138.04 | 127.817186713996 | 128.584857505071 | 125.9528433642422 | 126.1539 | 19843779
JPM | 2021-01-20 00:00:00 | 137.82 | 138.17 | 135.435 | 135.97 | 125.9528029859528 | 126.2726657130249 | 123.7731669743326 | 124.2621 | 16028850
JPM | 2021-01-21 00:00:00 | 135.69 | 136.16 | 134.325 | 134.83 | 124.0062486612772 | 124.435778743603 | 122.7587836349477 | 123.2203 | 13415020
JPM | 2021-01-22 00:00:00 | 132.69 | 134.4 | 132.2 | 133.79 | 121.2645172434412 | 122.8272749831826 | 120.816709470065 | 122.2698 | 12933230
JPM | 2021-01-25 00:00:00 | 132.14 | 133.17 | 130.06 | 132.12 | 120.7618778686043 | 121.7031881017257 | 118.8609795337572 | 120.7436 | 14212760
JPM | 2021-01-26 00:00:00 | 132.75 | 133.17 | 131.34 | 131.58 | 121.3193553351573 | 121.7031905836753 | 120.0307655722754 | 120.2501 | 11307820
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-07 00:00:00 | 0.12
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-03-31 00:00:00 | 0.13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-01 00:00:00 | 0.13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-10-07 00:00:00 | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-06 00:00:00 | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-07 00:00:00 | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-07 00:00:00 | 0.16
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-06 00:00:00 | 0.16
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-05 00:00:00 | 0.16
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-05 00:00:00 | 0.16
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-06 00:00:00 | 0.16
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-05 00:00:00 | 0.16
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-04 00:00:00 | 0.16
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-04-04 00:00:00 | 0.16