Excel ADDRESS Function

    how to use excel address function

    Quick Intro

    Use Excel ADDRESS Function to create a cell address by specifying a row and a column number.

    In simple words, you can create a reference by providing row and column number as a argument. And, with these arguments, it will return a cell range as a text.

    For example, if you give row number 2 and column number 1 it will return A2 in the result.

    Syntax

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

    • row_num A number to specify row number.
    • column_num  A number to specify column number.
    • [abs_num]  Reference type.
    • [A1] Reference style.
    • [sheet_text] A text value as a sheet name.

    Wondering some of above arguments are in square brackets. Well, these all are 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.

    Examples

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

    Examples For Excel ADDRESS Function

    1. With R1C1 reference style
      1. relative reference.
      2. Relative row and absolute column reference.
      3. Absolute row and relative column reference.
      4. Absolute reference.
    2. With A1 reference style
      1. Relative reference.
      2. Relative row and absolute column reference.
      3. Absolute row and relative column reference.
      4. Absolute reference.

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel ADDRESS Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

    There is also you have INDIRECT  function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples for you.