I am trying to get the value of a cell based on the last value of a row that used the lookup formula.
Let's say in cell A1, I referenced the last value of the row 300 on the sheet 2 renamed Notes. I used the Lookup function:
A1 value: (=LOOKUP(9.99999999999999E+307,Notes!300:300). The value in A1 equals to the year 2010 value. Its cell ref is M300.
In the cell A2, I want to see the value of the year 2009, which is located on the same sheet (Notes). The cell ref is L300. But instead of calling the cell by typing =Notes!L300, I want excel to find the value of cell A2, based on that of cell A1. In other words, if the last value of the row 300 in 10 years is that of 2020, excel will put in the cell A2, the value of year 2019 automatically.
Thank you for the help.
Let's say in cell A1, I referenced the last value of the row 300 on the sheet 2 renamed Notes. I used the Lookup function:
A1 value: (=LOOKUP(9.99999999999999E+307,Notes!300:300). The value in A1 equals to the year 2010 value. Its cell ref is M300.
In the cell A2, I want to see the value of the year 2009, which is located on the same sheet (Notes). The cell ref is L300. But instead of calling the cell by typing =Notes!L300, I want excel to find the value of cell A2, based on that of cell A1. In other words, if the last value of the row 300 in 10 years is that of 2020, excel will put in the cell A2, the value of year 2019 automatically.
Thank you for the help.
...
