Return a worksheet column letter (ranging from A to XFD) for the value contained in cell A1. : ADDRESS « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial

Home Microsoft Office Excel 2007 Tutorial 1. Introduction 2. Editing 3. Format Style 4. Table 5. Chart 6. Formula 7. Workbook Worksheet 8. Wordart Clip Art Shape Picture 9. PivotTable PivotChart 10. Data Analysis 11. Macro ActiveX Add in 12. Security 13. Collaboration 14. Database functions 15. Date Time functions 16. Engineering functions 17. Information functions 18. Logical functions 19. Lookup Reference functions 20. Math Trigonometry functions 21. Statistical functions 22. Text functions VBA / Excel / Access / Word Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Word 2007 Tutorial

Microsoft Office Excel 2007 Tutorial » Lookup Reference functions » ADDRESS   19.1.7.Return a worksheet column letter (ranging from A to XFD) for the value contained in cell A1. Input the formula: =LEFT(ADDRESS(1,A1,4),FIND(1,ADDRESS(1,A1,4))-1) 19.1.ADDRESS 19.1.1. ADDRESS(row_num,column_num,abs_num,a1,sheet_text) returns a reference as text to a single cell in a worksheet 19.1.2. =ADDRESS(2,3) returns Absolute reference 19.1.3. =ADDRESS(2,3,2) return absolute row; relative column 19.1.4. =ADDRESS(2,3,2,FALSE) return absolute row; relative column in R1C1 reference style 19.1.5. =ADDRESS(2,3,1,FALSE,"[Book1]Sheet1") return absolute reference to another workbook and worksheet 19.1.6. =ADDRESS(2,3,1,FALSE,"EXCEL SHEET") return absolute reference to another worksheet 19.1.7. Return a worksheet column letter (ranging from A to XFD) for the value contained in cell A1.