» 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?Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
