non-random ramble :: Reference the cell value in XL from a string

{ 22 06 2006 02:06 }

Reference the cell value in XL from a string

So I want to put in a formula that retrieves its value from a cell where i say “get me the value of cell 1, 3″

2 Steps:

ADDRESS(x, y)

Returns the String Reference for this position

e.g. $A$1

THen INDIRECT(ref)

returns the value of the cell

INDIRECT(ADDRESS(1, 2))

wahey!