INDIRECT.
HTH
Jason
Atlanta, GA
-----Original Message-----
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?
.
|