[]

Document Solutions for Excel, .NET Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
  - ADDRESS
  - AREAS
  - CHOOSE
  - CHOOSECOLS
  - CHOOSEROWS
  - COLUMN
  - COLUMNS
  - DROP
  - EXPAND
  - FILTER
  - FORMULATEXT
  - GETPIVOTDATA
  - GROUPBY
  - HLOOKUP
  - HSTACK
  - HYPERLINK
  - IMAGE
  - INDEX
  - INDIRECT
  - LOOKUP
  - MATCH
  - OFFSET
  - PIVOTBY
  - ROW
  - ROWS
  - SINGLE
  - SORT
  - SORTBY
  - TAKE
  - TOCOL
  - TOROW
  - TRANSPOSE
  - TRIMRANGE
  - UNIQUE
  - VLOOKUP
  - VSTACK
  - WRAPCOLS
  - WRAPROWS
  - XLOOKUP
  - XMATCH
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
- Web Functions
File Operations
Document Solutions Data Viewer
API Reference
Release Notes

ADDRESS

This function uses the row and column numbers to create a cell address in text.

Syntax

ADDRESS(row, column, [absnum], [a1style], [sheettext])

Arguments

This function has these arguments:

Argument	Description
row	[Required] Row number in the cell reference
column8	[Required] Column number in the cell reference
absnum	[Optional] Type of reference to return; can be any of:
	Value - Type of Cell Reference Returned
	1 or omitted - Absolute
	2 - Absolute row, relative column
	3 - Relative row, absolute column
	4 - Relative
a1style	[Optional] Logical value that indicates whether the reference style is A1; if TRUE or omitted, the style is A1; if FALSE, then the style is R1C1
sheettext	[Optional] Name of the sheet to use as an external reference; if omitted, no sheet name is used

Examples

ADDRESS(2,4,2,FALSE)