Knowing Address Function and 10 Different Ways to Use it

The address function is useful when obtaining an address that belongs to a cell in the worksheet, giving it a specified row and the column numbers. For example, using Address(4,3) would return with $C$4.

Address Function and Parameters

The address function has different parameters, which are row number, column number, followed by abs number, then a1, and finally the sheet text. Some parameters are standard, while others are optional.

Row number (row_num): This is a required part of the function, and is a value of number that would specify the row number that the function would use in cell reference.

Column number (column_num): This is also required, and normally a value of numbers that would specify on row number to use in references of cell.

Abs Number [abs_num]: This is an optional part of the function, and usually a value of number that will specify the type of reference it would return to.

A1 [a1]: This is optional, and a logical value that will specify either an A1 or R1C1 style of reference. In the A1 style, the column would alphabetically be labeled, while rows would numerically be labeled. If the argument has been sets to true, or even omitted, then the function would be returning an A1 kind of reference. If it is false, then it would return with the R1C1 kind of reference. In the R1C1 reference style, then both of the rows and columns would be numerically labeled.

Sheet Text (Sheet_text): This is optional, and a argues for a text value that would specifies name of the worksheet that is being used as the external reference, which means that =ADDRESS(1,1,,,"Sheet1") will be returning with Sheet1!$A$1. This can be omitted, which would result in the address function arguing that there is no sheet name being used in the function.

Example 1: Simple Address Formula

This is under the circumstances that we are using the formula to find a specific address to numeric values that would make it possible to find the right value.

Simple Address Formula

Example 2: Address Formula with Text

This example is about specifying the address of a cell with formula that also has text. In this example, we are going to be using the address formula to get the address to this information.

Address Formula with Text

Example 3: Address and Match Formula Simultaneously

In this example, we are using the match and address formula to find the address of the information given to the formula that has been written to it.

Address and Match Formula Simultaneously

Example 4: Address and Match in a Respective Formula

The example would be using both the match and address formula that would be used to find the answer.

Address and Match in a Respective Formula

Example 5: Match, Address and Max in One Formula

This example is combining the three formula into one single formula to find the address to one simple and yet comprehensive formula that makes finding the answer an easy process.

Match Address and Max in One Formula

Example 6: Three Different Formulas with Address

This example is about using the address, match and max formula, but this time it would be quite different, because there will be separation between the formulas.

Three Different Formulas with Address

Example 7: Formula for Finding Address with Min Formula

This formula is about finding the address, with two different formula that are in a single formula and get the answer that we are looking for, with the formula.

Formula for Finding Address with Min Formula

Example 8: Min, Match and Address in a Single Formula

The formula is combining three different formulas to find the address for a specific information that we are looking for, and we are going to use the formula needed to get answers.

Min Match and Address in a Single Formula

Example 9: Using Three Different Formula in two Different Formulas

The example is focusing on finding the answer needed to perform a specific duty, and we need to know the address of the formulas.

Using Three Different Formula in two Different Formulas

Example 10: Address and Min Formula with Different Spreadsheet

In this example, we'd have two different sheets, and wants to use another spreadsheet to find the address that we are looking for, with both the min and address formula.

Address and Min Formula with Different Spreadsheet