Indirect cell reference

T

Tony McGee

Hello

How do I indirectly reference a cell in another worksheet in the same
workbook using the Row() & Column() functions.. Every variation of any
formula I have tried results in a formula error.

Thanks
Tony McGee
 
D

Debra Dalgleish

To refer to a cell in the same row and column on sheet2:

=INDIRECT("Sheet2!"&ADDRESS(ROW(),COLUMN()))
 
H

Harlan Grove

Debra Dalgleish said:
To refer to a cell in the same row and column on sheet2:

=INDIRECT("Sheet2!"&ADDRESS(ROW(),COLUMN()))
Click to expand...
....

Or

=INDIRECT("Sheet2!RC",0)
 
Top