HomeExcel Functions ► Excel ADDRESS Function

Syntax For Excel ADDRESS Function

What is the use of Excel ADDRESS Function?

Use Excel ADDRESS Function to create a cell address by specifying row & column number. In simple words, You have specified the row number, column number, reference type, reference style & sheet name. And, with these arguments, it will return a cell range as a text. for example, if you give row number 2 & column number 1 it will return A2 in the result.

Syntax for Excel ADDRESS Function

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

row_num A number to specify row number. [Required]

column_num  A number to specify column number. [Required]

abs_num  Reference type. [Optional]

A1 Reference style. [Optional]

sheet_text A text value as a sheet name. [Optional]

More Information on Excel ADDRESS Function

  • If you want to use the result return by address function as a cell reference  you can do it by using Indirect Function

Examples to understand Excel ADDRESS Function

Examples For Excel ADDRESS Function

In above example, I have used different arguments to get all types of results.

  1. R1C1 reference style with relative reference.
  2. R1C1 reference style with relative row & absolute column reference.
  3. R1C1 reference style with absolute row & relative column reference.
  4. R1C1 reference style with absolute reference.
  5. A1 reference style with relative reference.
  6. A1 reference style with relative row & absolute column reference.
  7. A1 reference style with absolute row & relative column reference.
  8. A1 reference style with absolute reference.

You can use different reference style as per your need.

Download Sample File

Download Sample File To Learn Excel ADDRESS Function

More Tips Related With Excel ADDRESS Function

Conclusion

Use Excel ADDRESS Function to create a cell address by specifying row & column number. Learn about ADDRESS from here.

Related Tips

R1C1 Reference Style

Related Function

Indirect

Excel Functions | Excel Formulas