I am trying to create a table on one sheet that requires a formula using values from another sheet. Is there a way to use the value of a cell on my current sheet and reference a corresponding cell from another sheet in the formula?
For example, if the value in D3 is 85, I would like for the formula to refer to cell N88 from the other sheet, which contains the value that I need for the calculation. The value in D3 will change daily, as it is based on the number of days from a specified date in the past up to 120 days. There are 120 cells in N88 that would be referenced.
Is there any way to do this? HELP!!!
Bookmarks