What is ADDRESS Function in Excel?
The ADDRESS function is one of the Lookup & reference functions of Excel.
It Creates a cell reference as text, given specified row and column numbers.
We can find this function in Lookup & reference of insert function Tab.
How to use ADDRESS function in excel
- Click on an empty cell (like F5 ).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Lookup & reference category.
5. Select ADDRESS function.
6. Then select ok.
7. In the function arguments Tab, you will see ADDRESS function.
8. Row num is the row number to use in the cell reference. For example,Row number = 1 for row 1.
9. Column_num section is the column number to use in the cell reference. For example, Column number = 4 for column D.
10. Abs num specifies the reference type: absolute = 1; absolute row/relative column = 2; relative row/absolute column = 3; relative = 4.
11. A1 is a logical value that specifies the reference style: A1 style = 1 or TRUE; R1 C1 style = 0 or FALSE.
12. Sheet text is text specifying the name of the worksheet to be used as the external reference.
13. You will see the result in formula result section.
Examples of ADDRESS function in excel
ADDRESS related functions
- INDIRECT function
- ROW function
