I have a spreadsheet in Excel with columns like Date, Open, High, Low and Close. The next column has entries with positive integers. If the entry is X, I want to display the Open of X-days ago in the next column.
For example, the first row contains column headers and cell B6 contains the...