Address() function in Excel
The address() function returns the cell address in text format of a defined
row and column. The Excel ADDRESS function returns the address for a cell of a row and column number. For example, ADDRESS(2,7) returns $B$7. ADDRESS(row,column, relative or absolute) can return a relative address or absolute address.
Address Example: =ADDRESS(2,2) will give you $B$2
This is useful for browsing tables or finding values
somewhere in the sheet.
![ADDRESS function excel](images/img1A6.png)
Use it in conjunction with INDIRECT and you have a very
powerful tool.
Columns function, Rows function in Excel
The Excel Rows Function and Columns functions give you the number of columns and rows in a
table.
This is very useful when you have a big table and want to know its size.
![rows and columns in excel](images/img1C4.png)
Column, Row function (without an s)
This function returns the Column and Row value of a certain cell
Like COLUMN(C2) will give you 3. ROW(C2) will of course give 2.
![column row function](images/image-excel-row-column-img1D6.png)
Here an example on how to find the address of a name in a table. It uses the
MATCH, ROW, COLUMN, ADDRESS and
INDIRECT functions
![indirect match](images/image-excel-function-address-img161.png)
The important is that you understand how these functions can be used
together.
Please Tweet, Like or Share us if you enjoyed.