Menu
EXCEL ADDRESS FUNCTION
Excel ADDRESS Function Introduction
From a specified row and column, this method generates a cell address. ADDRESS(5,3),
Description of Excel ADDRESS Function
Syntax:
=ADDRESS (row_num, col_num, [abs_num], [a1], [sheet_text])
Parameter list:
- The row number to use in the cell address is row num.
- The column number to use in the cell address is col num.
- abs num – [optional] the type of address (i.e. absolute, relative). The value is set to absolute by default.
- A1 versus R1C1 is an optional reference style. The default style is A1.
- sheet text – the name of the worksheet to utilize (optional). The current sheet is used as a default.
Step By Step Guide of ADDRESS Function
Example :
we will get $M$23, for =ADDRESS(B6,B8).
other example, returns $B$42, for =ADDRESS(B7,B9).
supply the row and column number parameters for the ADDRESS function, you can utilise other functions like
the ROW and COLUMN functions.
Related Functions
INDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowHLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
