Spreadsheet: 839684d1692158266-formula-looking-at-previous-column-data-points-read-table
Sheet: Table1

 | What I have. |  |  |  |  |  |  |  |  |  |  |  | What I need. Starting in column S23. If there is a # in r23, need S23 to provide the previous # from column R. Then need the # previous to the previous # in T23
Date | Market High | Market Lo | Market Close | Pivot | 1st Read |  |  | 2nd Read |  |  |  | Date | Market High | Market Lo | Market Close | Pivot | 1st Read |  |  | 2nd Read
2021-09-03 00:00:00 | 1.19082 | 1.1865 | 1.18774 |  |  |  |  |  |  |  |  | 2021-09-03 00:00:00 | 1.19082 | 1.1865 | 1.18774
 | 1.18858 | 1.18552 | 1.18676 |  |  |  |  |  |  |  |  |  | 1.18858 | 1.18552 | 1.18676
 | 1.18845 | 1.18367 | 1.1839 |  |  |  |  |  |  |  |  |  | 1.18845 | 1.18367 | 1.1839
 | 1.18507 | 1.18014 | 1.18136 |  |  |  |  |  |  |  |  |  | 1.18507 | 1.18014 | 1.18136
 | 1.18404 | 1.18044 | 1.18228 |  |  |  |  |  |  |  |  |  | 1.18404 | 1.18044 | 1.18228
 | 1.18505 | 1.18086 | 1.18095 |  |  |  |  |  |  |  |  |  | 1.18505 | 1.18086 | 1.18095
 | 1.18165 | 1.17694 | 1.18094 |  |  |  |  |  |  |  |  |  | 1.18165 | 1.17694 | 1.18094
 | 1.1845 | 1.17994 | 1.18014 |  |  |  |  |  |  |  |  |  | 1.1845 | 1.17994 | 1.18014
 | 1.18312 | 1.17983 | 1.18152 |  |  |  |  |  |  |  |  |  | 1.18312 | 1.17983 | 1.18152
 | 1.18201 | 1.17496 | 1.17633 |  |  |  |  |  |  |  |  |  | 1.18201 | 1.17496 | 1.17633
 | 1.17882 | 1.17233 | 1.17237 |  |  |  |  |  |  |  |  |  | 1.17882 | 1.17233 | 1.17237
 | 1.17359 | 1.16993 | 1.17235 |  |  |  |  |  |  |  |  |  | 1.17359 | 1.16993 | 1.17235
 | 1.17481 | 1.17142 | 1.17232 |  |  |  |  |  |  |  |  |  | 1.17481 | 1.17142 | 1.17232
 | 1.17543 | 1.16838 | 1.16861 |  |  |  |  |  |  |  |  |  | 1.17543 | 1.16838 | 1.16861
 | 1.17494 | 1.16828 | 1.17377 |  |  |  |  |  |  |  |  |  | 1.17494 | 1.16828 | 1.17377
 | 1.17468 | 1.16999 | 1.17187 |  |  |  |  |  |  |  |  |  | 1.17468 | 1.16999 | 1.17187
 | 1.17257 | 1.16843 | 1.16945 |  |  |  |  |  |  |  |  |  | 1.17257 | 1.16843 | 1.16945
 | 1.17028 | 1.16674 | 1.16824 |  |  |  |  |  |  |  |  |  | 1.17028 | 1.16674 | 1.16824
 | 1.16896 | 1.15886 | 1.15963 |  |  |  |  |  |  |  |  |  | 1.16896 | 1.15886 | 1.15963
 | 1.1609 | 1.1562 | 1.15754 |  |  |  |  |  |  |  |  |  | 1.1609 | 1.1562 | 1.15754
 | 1.16067 | 1.15623 | 1.15918 |  |  |  |  |  |  |  |  |  | 1.16067 | 1.15623 | 1.15918 |  |  | 1.1749 | 1.1736
 | 1.16393 | 1.15871 | 1.16183 |  |  |  |  |  |  |  |  |  | 1.16393 | 1.15871 | 1.16183
 | 1.16215 | 1.15798 | 1.15963 |  |  |  |  |  |  |  |  |  | 1.16215 | 1.15798 | 1.15963
 | 1.1601 | 1.15286 | 1.15533 |  |  |  |  |  |  |  |  |  | 1.1601 | 1.15286 | 1.15533
 | 1.15715 | 1.15468 | 1.15488 |  |  |  |  |  |  |  |  |  | 1.15715 | 1.15468 | 1.15488
 | 1.15852 | 1.15406 | 1.15684 |  |  |  |  |  |  |  |  |  | 1.15852 | 1.15406 | 1.15684 |  |  | 1.1639 | 1.1607
 | 1.15861 | 1.15483 | 1.15495 |  |  |  |  |  |  |  |  |  | 1.15861 | 1.15483 | 1.15495
 | 1.15697 | 1.15235 | 1.15288 |  |  |  |  |  |  |  |  |  | 1.15697 | 1.15235 | 1.15288
 | 1.15968 | 1.15242 | 1.15904 |  |  |  |  |  |  |  |  |  | 1.15968 | 1.15242 | 1.15904 |  |  | 1.1585 | 1.1639
 | 1.16237 | 1.15833 | 1.1595 |  |  |  |  |  |  |  |  |  | 1.16237 | 1.15833 | 1.1595
 | 1.16183 | 1.15875 | 1.15987 |  |  |  |  |  |  |  |  |  | 1.16183 | 1.15875 | 1.15987
 | 1.1622 | 1.15711 | 1.16085 |  |  |  |  |  |  |  |  |  | 1.1622 | 1.15711 | 1.16085 |  |  | 1.1597 | 1.1585
 | 1.16685 | 1.16075 | 1.1631 |  |  |  |  |  |  |  |  |  | 1.16685 | 1.16075 | 1.1631
 | 1.16579 | 1.16162 | 1.16487 |  |  |  |  |  |  |  |  |  | 1.16579 | 1.16162 | 1.16487 |  |  | 1.1622 | 1.1597
 | 1.16668 | 1.16189 | 1.16213 |  |  |  |  |  |  |  |  |  | 1.16668 | 1.16189 | 1.16213
 | 1.1655 | 1.162 | 1.16377 |  |  |  |  |  |  |  |  |  | 1.1655 | 1.162 | 1.16377 |  |  | 1.1658 | 1.1622
 | 1.16646 | 1.15898 | 1.16056 |  |  |  |  |  |  |  |  |  | 1.16646 | 1.15898 | 1.16056
 | 1.16253 | 1.15842 | 1.15945 |  |  |  |  |  |  |  |  |  | 1.16253 | 1.15842 | 1.15945
 | 1.16252 | 1.15843 | 1.16017 |  |  |  |  |  |  |  |  |  | 1.16252 | 1.15843 | 1.16017
 | 1.16914 | 1.15816 | 1.16782 |  |  |  |  |  |  |  |  |  | 1.16914 | 1.15816 | 1.16782 |  |  | 1.1655 | 1.1658