Using a function to specify a cell

T

trollsoft

Say I want to specify the cell whose column is C and whose row is the
returned value of a function (say row()). How would I accomplish that?

The incorrect syntax would be Crow(). What would be a way to do it correctly?

thanks.
 
R

Ron Rosenfeld

Say I want to specify the cell whose column is C and whose row is the
returned value of a function (say row()). How would I accomplish that?

The incorrect syntax would be Crow(). What would be a way to do it correctly?

thanks.
Click to expand...

=ADDRESS(ROW(),3) would return the cell address

=INDIRECT("C"&ROW()) or
=INDIRECT(ADDRESS(ROW(),3))

would return the contents of the cell at that address. However, if the
cell is blank, these formulas will return a zero.


--ron
 
Top