So, I am trying to use a number stored in a cell to look that number of cells
up, down, right, or left of a different cell. I have figured out how to get
the address of the new cell using the ADDRESS function. For example:
=ADDRESS(ROW(A1)+5, COLUMN(A1)). This will look 5 cells down from A1.
However, this just returns the address of the cell. That equation would
return "A6." What funciton can I nest ADDRESS in to give me the contents of
this new cell?