» Return the cell reference as text in Microsoft Excel
CATEGORY - Working with Formulas
VERSION - All Microsoft Excel Versions
Row number in cell A1: 2
Column number in cell A2: 3
Sheet name in cell A3: ExcelTip
The Function : =ADDRESS(A1,A2,4,TRUE,A3)
Result: ExcelTip!C2
Formula Description (Result)
=ADDRESS(2,3) Absolute reference ($C$2)
=ADDRESS(2,3,2) Absolute row; relative column (C$2)
=ADDRESS(2,3,2,FALSE)
Absolute row; relative column in R1C1 reference style (R2C[3])
=ADDRESS(2,3,1,FALSE,"[Book1]Sheet1")
Absolute reference to another workbook and worksheet ([Book1]Sheet1!R2C3)
=ADDRESS(2,3,1,FALSE,"EXCEL SHEET")
Absolute reference to another worksheet ('EXCEL SHEET'!R2C3)
Book Store:
Recommended Books:
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Excel 2002 Power Programming with VBA
- Financial Statement Analysis with S&P insert card
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Personal Finance for Dummies
- Keys to Reading an Annual Report (Barron's Business Keys)
But then...?
Will Posted on: 31-12-1969
This gave me the name of the cell I was after, but how do I get to the contents of that cell? Without directly referencing it, that is. I have a summary sheet and lots of data sheets, and want to just copy down a row when I add a data sheet.But then!
Dave Gulliksen Posted on: 31-12-1969
This formula will return the contents of the cell:
=INDIRECT(ADDRESS(A1,A2,4,TRUE,A3))
INDIRECT changes a text address to one that can be used in a formula. But be aware this will only work if the workbook you're referencing is open.
But Then....?
Donovan Marsh Posted on: 31-12-1969
I am trying to do this with a defined area in an array and INDIRECT does not work. Any ideas?

