Indirect cell reference

  • Thread starter Thread starter Tony McGee
  • Start date Start date
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
 
To refer to a cell in the same row and column on sheet2:

=INDIRECT("Sheet2!"&ADDRESS(ROW(),COLUMN()))
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indirect 1
Using INDIRECT Function and INDEX Function 1
INDIRECT 2
Formula Simplifications Using Nested If, Indirect & Address Functi 3
Indirect and sumif functions with multiple workbooks 1
Excel VBA 1
Formula that sums/counts across worksheets with variable reference 1
enter named range as opposed to cell ref. 1

Back
Top