Tip Printed from ExcelTip.com
Return the cell reference as text in Microsoft Excel




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)