» 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:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Microsoft Windows XP Inside Out
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
No comments have been submitted.
