Microsoft Office Tutorials and References
In Depth Information
Finding Where It Is
Use ADDRESS this way:
1. Click a cell where you want the result to appear.
2. Enter =ADDRESS( to start the function.
3. Enter a row number, a comma ( ,), and a column number.
You can also enter references to cells where those values are located.
enter a comma ( ,) and the appropriate number: 2, 3, or 4.
5. If you want the result to be returned in R1C1 style, then enter a
comma ( ,) and enter 0.
6. If you want the result to be a reference to another worksheet, then
Or, if you want the result to be a reference to an external workbook,
then enter a comma and enter the workbook name and worksheet name
together. The workbook name goes in brackets, and the entire reference
goes in double quote marks, such as this: “[Book1]Sheet2”.
7. Enter a ), and press Enter.
Instead of directly entering a row number and column number into ADDRESS,
you can enter cell references. However, the values you find in those cells must
evaluate to numbers that can be used as a row number and column number.
ROW, ROWS, COLUMN, and COLUMNS
The ADDRESS function is rarely used on its own. Most often it is used as part
of a more complex formula. A useful example of ADDRESS follows the
discussion of ROW, ROWS, COLUMN, and COLUMNS.
ROW and COLUMN are passed a reference to a cell or range and return the
row number or the column number, respectively. Sounds simple enough.
These functions take a single optional argument. The argument is a reference
to a cell or range. The function returns the associated row number or column
number. When the reference is a range, it is the first cell of the range (the
upper left) that is used by the function.
ROW and COLUMN are particularly useful when the argument is a name
(for a named area). When you use ROW or COLUMN without an argument, it
returns the row number or column number of the cell the function is in. What
the point of that is, I don’t know. Here are examples of ROW and COLUMN: