Return the cell reference as text in Microsoft Excel

by  About
       

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)


3 thoughts on “Return the cell reference as text in Microsoft Excel

  1. 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.

  2. “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.”

Leave a Reply

Your email address will not be published. Required fields are marked *


× five = 45

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>