For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Lookup and reference

ADDRESS Function

Returns a reference as text to a single cell in a worksheet


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Creates a cell address as text, given row and column numbers. Optional arguments can specify the type of address returned.

Syntax

ADDRESS(row_num, column_num, abs_num, a1, sheet_text)

  • row_num  Required. The row number to use for the cell address
  • column_num  Required. The column number to use for the cell address
  • abs_num Optional. (Default =1) Specifies the type of reference to return, where...
    • 1 returns an absolute reference as text
    • 2 returns an absolute row and a relative column
    • 3 returns a relative row and an absolute column
    • 4 returns a relative address
  • a1  Optional. (Default=TRUE) Specifies an A1 or R1C1 address.
    • If TRUE, a non-zero number, or omitted, returns an A1-style reference.
    • If FALSE or zero, returns an R1C1-style reference.
  • sheet_text  is text that specifies the name of the worksheet to be used as an external reference. If sheet_text is omitted, no sheet name is returned.

Applies To

Excel 2003 and above

Examples

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Examples for Excel's ADDRESS function

Use the INDIRECT function in combination with ADDRESS to obtain a cell reference for a specific row and column number. To illustrate, in this figure, row 2 column 6 is cell F2, which contains the text "Result". Therefore, the formula in cell F14 returns the text Result.

Other Help

Related Functions

In total, Excel 2013 offers 15 functions that round data in various ways. Here's a summary of Excel's rounding functions.

 

Charley's SwipeFile charts


Free Excel Dashboards