Spreadsheet: 832537d1686411752-formula-looking-back-one-day-at-a-time-to-find-a-between-the-hi-lo-range-base-read
Sheet: Sample

 | Hi | [NAME] | Close | Pivot | Pips | Est | Hi Dif. | [NAME]. | Current formula provides this |  |  | Need a formula to scan column J, & find 1st result (#) that is between current day Hi / Lo. |  | Need this as the new solution
2021-09-03 00:00:00 | 0.93475 | 0.92808 | 0.9331
 | 0.93408 | 0.93112 | 0.93187 | 0.9322
 | 0.93508 | 0.92968 | 0.93353
 | 0.93738 | 0.93237 | 0.9342
 | 0.93758 | 0.93153 | 0.93239
 | 0.93434 | 0.9302 | 0.93261
 | 0.93457 | 0.93051 | 0.93169
 | 0.9321 | 0.92711 | 0.92855
 | 0.92963 | 0.92532 | 0.92573
 | 0.92729 | 0.92296 | 0.924
 | 0.92821 | 0.9227 | 0.92768 |  |  |  |  |  | 0.9248 | C
 | 0.93149 | 0.92414 | 0.92932 |  |  |  |  |  |  | C
 | 0.93017 | 0.92524 | 0.92646 |  |  |  |  |  |  | C
 | 0.92943 | 0.92368 | 0.92501 |  |  |  |  |  |  | C
 | 0.92535 | 0.91995 | 0.92262 |  |  |  |  |  |  | C
 | 0.92503 | 0.91735 | 0.91778 |  |  |  |  |  |  | C
 | 0.92132 | 0.91667 | 0.9195 |  |  |  |  |  |  | C
 | 0.92109 | 0.91573 | 0.91759 |  |  |  |  |  |  | C
 | 0.92046 | 0.91423 | 0.9148 |  |  |  |  |  |  | C
 | 0.92022 | 0.91392 | 0.91587 |  |  |  |  |  |  | C
 | 0.92092 | 0.91527 | 0.91717 |  |  |  |  |  |  | C
 | 0.91986 | 0.91503 | 0.91606 |  |  |  |  |  |  | C
 | 0.91803 | 0.91461 | 0.91699 |  |  |  |  |  |  | C
 | 0.91737 | 0.91335 | 0.91508 |  |  |  |  |  |  | C
 | 0.9191 | 0.91468 | 0.91747
 | 0.91848 | 0.90999 | 0.90999
 | 0.91834 | 0.90973 | 0.91712 |  |  |  |  |  | 0.9128 | C
 | 0.92 | 0.91511 | 0.91577 |  |  |  |  |  | 0.9128 | C
 | 0.91836 | 0.91303 | 0.91759
 | 0.91903 | 0.91623 | 0.91694
 | 0.91927 | 0.91538 | 0.91662 |  |  |  |  |  | 0.9174 | C
 | 0.91919 | 0.91476 | 0.9169 |  |  |  |  |  | 0.9174 | C
 | 0.9248 | 0.9163 | 0.92328
 | 0.92677 | 0.92263 | 0.92548 |  |  |  |  |  | 0.9215 | C
 | 0.92777 | 0.92206 | 0.92289 |  |  |  |  |  |  | C
 | 0.9262 | 0.92176 | 0.92238 |  |  |  |  |  |  | C
 | 0.9287 | 0.92272 | 0.92698 |  |  |  |  |  |  | C
 | 0.93034 | 0.92613 | 0.92879
 | 0.93363 | 0.92488 | 0.92834 |  |  |  |  |  | 0.9284 | C
 | 0.93147 | 0.92937 | 0.93016 |  |  |  |  |  |  | C
 | 0.93277 | 0.92937 | 0.930001 |  |  |  |  |  |  | C
 | 0.93143 | 0.9281 | 0.93028 |  |  |  |  |  |  | C
 | 0.93211 | 0.92027 | 0.92154 |  |  |  |  |  |  | C
 | 0.92495 | 0.92042 | 0.9222 |  |  |  |  |  |  | C
 | 0.9247 | 0.91946 | 0.92138 |  |  |  |  |  |  | C
 | 0.92272 | 0.91786 | 0.92031 |  |  |  |  |  |  | C
 | 0.9249 | 0.91909 | 0.9231
 | 0.92404 | 0.91706 | 0.91712 |  |  |  |  |  | 0.9224 | C
 | 0.91812 | 0.91367 | 0.91444 |  |  |  |  |  |  | C
 | 0.91962 | 0.91248 | 0.91687 |  |  |  |  |  |  | C
 | 0.92095 | 0.91548 | 0.91937 |  |  |  |  |  |  |  |  | 0.9174 | C | 0.9174 | C | .9174 is the first day there is a number between the Hi / Lo for the current row.
 | 0.92299 | 0.91831 | 0.91888 |  |  |  |  |  |  |  |  | 0.9224 | C | 0.9224 | C | .9224 is the first day there is a number between the Hi / Lo for the current row.
 | 0.92072 | 0.91634 | 0.91669 |  |  |  |  |  |  |  |  | 0.9174 | C | 0.9174 | C | .9174 is the first day there is a number between the Hi / Lo for the current row.
 | 0.91757 | 0.91368 | 0.91582 |  |  |  |  |  |  |  |  | 0.9174 | C | 0.9174 | C | .9174 is the first day there is a number between the Hi / Lo for the current row.
 | 0.91893 | 0.91514 | 0.9164 |  |  |  |  |  |  |  |  | 0.9174 | C | 0.9174 | C | .9174 is the first day there is a number between the Hi / Lo for the current row.