<div class="raw-html-embed">    <p>The <b>ADDRESS</b> function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#lookupreference" onclick="onhyperlinkclick(this)">lookup and reference functions</a>. It is used to return a text representation of a cell address.</p>

    <h5 class="pt8">Syntax</h5>
    <p><b><em>ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])</em></b></p>
    <p>The <b>ADDRESS</b> function has the following arguments:</p>
    <table style="width: 40%">
        <tbody>
            <tr>
                <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
                <th style="background-color: #f4f4f4"><b>Description</b></th>
            </tr>
            <tr>
                <td><b><em>row_num</em></b></td>
                <td>A row number to use in a cell address.</td>
            </tr>
            <tr>
                <td><b><em>column_num</em></b></td>
                <td>A column number to use in a cell address.</td>
            </tr>
            <tr>
                <td><b><em>abs_num</em></b></td>
                <td>A type of reference. The possible values are listed in the table below.</td>
            </tr>
            <tr>
                <td><b><em>a1</em></b></td>
                <td>An optional logical value: TRUE or FALSE. If it is set to TRUE or omitted, the function will return an A1-style reference. If it is set to FALSE, the function will return an R1C1-style reference.</td>
            </tr>
            <tr>
                <td><b><em>sheet_text</em></b></td>
                <td>The name of the sheet to use in a cell address. It's an optional value. If it is omitted, the function will return the cell address without the sheet name indicated.</td>
            </tr>
        </tbody>
    </table>
    <p>The <b><em>abs_num</em></b> argument can be one of the following:</p>
    <table style="width: 40%">
        <tbody>
            <tr>
                <th style="background-color: #f4f4f4"><b>Numeric value</b></th>
                <th style="background-color: #f4f4f4"><b>Meaning</b></th>
            </tr>
            <tr>
                <td><b><em>1 or omitted</em></b></td>
                <td>Absolute referencing</td>
            </tr>
            <tr>
                <td><b><em>2</em></b></td>
                <td>Absolute row; relative column</td>
            </tr>
            <tr>
                <td><b><em>3</em></b></td>
                <td>Relative row; absolute column</td>
            </tr>
            <tr>
                <td><b><em>4</em></b></td>
                <td>Relative referencing</td>
            </tr>
        </tbody>
    </table>

    <h5 class="pt8">Notes</h5>
    <p><a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the <b>ADDRESS</b> function.</p>

    <h5 class="pt8">Examples</h5>
    <p>The figure below displays the result returned by the <b>ADDRESS</b> function.</p>
    <p><img alt="ADDRESS Function" src="https://static-helpcenter.teamlab.info/address_1df1b5d875.png"></p></div>

ADDRESS Function

Docs

Argument	Description
*row_num*	A row number to use in a cell address.
*column_num*	A column number to use in a cell address.
*abs_num*	A type of reference. The possible values are listed in the table below.
a1	An optional logical value: TRUE or FALSE. If it is set to TRUE or omitted, the function will return an A1-style reference. If it is set to FALSE, the function will return an R1C1-style reference.
*sheet_text*	The name of the sheet to use in a cell address. It's an optional value. If it is omitted, the function will return the cell address without the sheet name indicated.

Numeric value	Meaning
*1 or omitted*	Absolute referencing
2	Absolute row; relative column
3	Relative row; absolute column
4	Relative referencing

ADDRESS Function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud