## How to use the ADDRESS function

*Article updated on March 27, 2018*

The ADDRESS function returns the address of a specific cell, you need to provide a row and column number.

Formula in cell D3:

=ADDRESS(B3, C3)

### Excel Function Syntax

ADDRESS(*row_num*, *column_num*, [*abs_num*], [*a1*], [*sheet_text*])

### Arguments

row_num |
Required. A number representing the row number. |

column_num |
Required. A number representing the column number. |

[abs_num] |
Optional. Lets you choose the type of reference to return. 1 - Absolute. 2 - Absolute row, relative column. 3 - Absolute column, relative row. 4 - Relative. |

[a1] |
Optional. Lets you choose reference style. A1 reference style is the default setting you are probably used to. The R1C1 reference style has both columns and rows are labeled numerically. TRUE - A1-style reference. FALSE - R1C1-style reference. |

[sheet_text] |
Optional. A text value that specifies the name of the worksheet to be used as the external reference. =ADDRESS(1,1,,,"Sheet2") returns Sheet2!$A$1. If omitted the function refers to a cell on the current sheet. |

### Articles with the 'ADDRESS' Function

The following 4 articles have formulas that contain the ADDRESS function.

Today I´ll show you how to search a table column and jump to that table cell using the hyperlink function. When […]

Question: I have three columns and how do I identify the largest and smallest number? Where is the value? I […]

Question: How do i get the cell adresses from the cells that contain TRUE? See picture below. Array formula in cell […]

Quickly select a data set or an excel defined table [HYPERLINK]

If you often copy data sets or tables, the following technique might be interesting! The animated gif shows two hyperlinks, […]### Functions in 'Lookup and reference'

The ADDRESS function function is one of many functions in the 'Lookup and reference' category.

The ADDRESS function returns the address of a specific cell, you need to provide a row and column number. Formula […]

The AREAS function returns the number of cell ranges and single cells in a reference. Formula in cell B3: =AREAS(E3:E4) […]

The CHOOSE function allows you to retrieve a value based on a number, cell range C3:C4 in the picture above […]

The COLUMN function returns the column number of the top left cell of a cell reference. If the argument is not […]

The COLUMNS function allows you to calculate the number of columns in a cell range. The example above shows that cell […]

The FORMULATEXT function returns a formula as a text string. Formula in cell C3: =FORMULATEXT(B3) Excel Function Syntax FORMULATEXT(reference) Arguments […]

The HLOOKUP function lets you search the top row in a data range for a value and return another value […]

The HYPERLINK function allows you to build a link in a cell pointing to something else like a file, workbook, cell, […]

Gets a value in a specific cell range based on a row and column number.

The INDIRECT function returns the cell reference based on a text string and shows the content of that cell reference. […]

Finds a value in a sorted cell range and returns a value on the same row.

Identify the position of a value in an array.

In this post I am going to provide some basic examples to demonstrate how the OFFSET function works. I also […]

The ROW function calculates the row number of a cell reference. Excel Function Syntax ROW(reference) Arguments reference Optional. A reference […]

The ROWS function allows you to calculate the number of rows in a cell range. The example above shows that cell […]

The transpose function allows you to convert a vertical range to a horizontal range, or vice versa. A vertical range […]

The VLOOKUP function lets you search the leftmost column for a value and return another value on the same row […]