ADDRESS Function

For example, =ADDRESS(1,1) returns $A$1.

Note that ADDRESS returns a reference as atext value.

Note: ADDRESS is a special purpose function and is not necessary in most formulas.

Finally, thesheet_textargument is meant to hold a sheet name that will be prepended to the address.

Examples

Use ADDRESS to create an address from a given row and column number.

The bang out of information to be returned is specified asinfo_type.

To use the INFO function, supply the punch in of information you want as text.

There are seven types of information available, summarized in…