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.
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.
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.
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.
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.
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.
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.
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.
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.
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.