Excel’s INDIRECT function lets you specify a cell address INDIRECTly. The syntax of the ADDRESS function is as below: 2 Absolute row; relative column The Excel ADDRESS function returns a cell reference as a string, based on a row and column number. ADDRESS function returns the address of a specific cell (text value) pointed to by the column and row numbers. Get over 200 Excel shortcuts for Windows and Mac in one handy PDF. Ask Question Asked 3 years, 11 months ago. Previously In Excel Formulas: How to use ACCRINTM Function in Excel? ADDRESS Function in Excel returns or displays the address of a … ADDRESS can return an address in relative or absolute format, and can be used to construct a cell reference inside a formula. Examples use text functions -- LEFT, RIGHT, MID, SUBSTITUTE, FIND, SEARCH and more. Learn how to apply the Excel ADDRESS function using excel and VBA. Apart from SUM, INDIRECT is frequently used with other Excel functions such as ROW, COLUMN, ADDRESS, VLOOKUP, SUMIF, to name a few. Figure 1. As a worksheet function, the ADDRESS function can be entered as part of a formula in a cell of a worksheet. Excel Address Function is used to combine column number and row number to return Cell address in Text format. Here’s a detailed explanation of the same: The image given above is an example to explain the address function. column_num Required. The ADDRESS function returns a cell address as text, based on a row and column number. The syntax of the ADDRESS function is as follows: Now you know the INDIRECT function which will help you understand the efficient use excel formula. 3. Things to Note The ADDRESS function is used to create an address from a given row and column number. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. A numeric value that specifies the row number to use in the cell reference. ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text]). Some videos you may like Excel Facts Back into an answer in Excel Click here to reveal answer. If the A1 argument is TRUE or omitted, the ADDRESS function returns an A1-style reference; if FALSE, the ADDRESS function returns an R1C1-style reference. Description. The INDIRECT function is a cell reference function. =ADDRESS (row_num, col_num, [abs_num], [a1], [sheet]). How to use the ADDRESS function in Excel The Excel ADDRESS function returns a cell address as text based on given row and column number. For example, as a result of the function =ADDRESS (5;7), the value of $G$5 will be displayed. How do I specify the 'Address()' so that the Sum function accepts it? The Excel ADDRESS function returns the address for a cell based on a given row and column number. Find the address of Named Ranges In Excel, you can name range or ranges of cells, allowing you to simply refer to the named range instead of the cell reference. It returns a valid cell reference as per the column and row address. Description The ADDRESS function returns the cell address reference as text, based on the given column number and row number. INDIRECT function in Excel. How to use it. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. Using Excel INDIRECT Function with Data Validation. You can use the ADDRESS function to obtain the address of … You can use the Excel ADDRESS function to get the address for cells in a worksheet, based on particular rows and columns. Column_num (required argument) – A numeric value specifying the column number to be used in the cell reference. It can be used as a worksheet function (WS) in Excel. Read more. Range.Address property (Excel) 05/10/2019; 2 minutes to read; o; O; k; J; S; In this article. In A1 style, columns are labeled alphabetically, and rows are labeled numerically. ADDRESS(Row, Column, Reference Type, Address Type, Sheet Name)Row (required) – This is a number that specifies the row of the address. Excel Address Function is used to combine column number and row number to return Cell address in Text format. Under Working with formulas, select or clear the R1C1 reference style check box. To do this, we'll need to figure out which row and which column the current cell is in. The ADDRESS function is a built-in function in Excel that is categorized as a Lookup/Reference Function. Now that we understand how to use the ADDRESS function, let's extend it to find the address of the current cell, i.e. Figure 1. The ADDRESS() function does just that. ADDRESS(Row, Column, Reference Type, Address Type, Sheet Name)Row (required) – This is a number that specifies the row of the address. This function returns an address either in a relative or absolute format. This function is very useful especially when you are dealing with different and large-scale spreadsheets in Excel 2010 workbook. column_num Required. The Excel ADDRESS function returns the address of a cell as text, based on a given row and column number. The Microsoft Excel ADDRESS function returns a text representation of a cell address. This article provides a clear guide on how to use the Excel ADDRESS function. Address Function in Excel is used to find out the address of a cell in a worksheet. A numeric value that specifies the column number to use in the cell reference. As you may remember, the ADDRESS function is used in Excel to get a cell address by the row and column numbers. Let`s work on an example where total and average sales of years 2016, 2017, and 2018 are given in three different sheets. The Excel spreadsheet contains a cell that displays dynamically changing data depending on certain conditions. It provides a reference to a cell and not the contents of the cell. INDIRECT and ROW functions. Active 3 years, 11 months ago. You can use the Excel ADDRESS function to get the address for cells in a worksheet, based on particular rows and columns. For formulas to show results, select them, press F2, and then press Enter. Syntax of the formula Excel ADDRESS function provide list of options to show address in desired ways; with row/column headers or row/column numbers, with absolute, relative or mixed format, etc. 1) If you just enter the row and column arguments in the ADDRESS function, =ADDRESS(A2,B2) Thanks in advance. LinkBack URL; About LinkBacks; Thread Tools. What is the Microsoft Excel ADDRESS Function? The ADDRESS function is a computer program that you run from a worksheet cell formula. ADDRESS in Excel Address Function is a pre-built integrated function in excel that is categorized under Lookup and Reference functions. Excel VBA equivalent of ADDRESS function. Our goal is to help you work faster in Excel. As another example, ADDRESS(77,300) returns $KN$77. The ADDRESS function is a lookup type function. expression.Address (RowAbsolute, ColumnAbsolute, ReferenceStyle, External, RelativeTo)expression A variable that represents a Range object. Some videos you may like Excel Facts Back into an answer in Excel Click here to reveal answer. CONCATENATE function is used for joining the several text string into one text string. The ADDRESS function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. 1 or omitted Absolute For example, the formula =ADDRESS (1,3) returns the string $C$1 since C1 is the cell at the intersection of the 1 st row and 3 rd column. the cell in which we are writing our formula. If you need to, you can adjust the column widths to see all the data. The ADDRESS function is a built-in function in Excel that is categorized as a Lookup/Reference Function.It can be used as a worksheet function (WS) in Excel. ADDRESS can return an address in relative or absolute format, and can be used to construct a cell reference inside a formula. We want to find the total sales amount and average sales amount for each year on a different sheet. In this case, we want to get the first row and the first column used by the named range data (B5:D14). For example, if an entry is on cell B2 then the address for the same is B2. Address function in excel is used to find the address of the cell and the value returned by this function is absolute, it is an inbuilt function, this function has two mandatory arguments which is the row number and the column number, for example, if we use =Address (1,2) we will get output as $B$1. Yesterday, in the 30XL30D challenge, we found items in an array with the MATCH function, and learned that it plays nicely with other functions, like VLOOKUP and INDEX. 4 Relative. You can use it to create a cell address from some given row and column. Now if you need for next 20. I'm doing this so that I can automate the process of breaking up a curve to interpolate points. I'd like to create a range from two separate address functions. This function will return the address of a cell given a specified row and column index number. Column (required) – This is a number that specifies the column of the address. For example, the formula =ADDRESS (1,1) returns $A$1. How do I specify the 'Address()' so that the Sum function accepts it? This cheat sheet covers 100s of functions that are critical to know as an Excel analyst. Syntax. Thanks in advance. If the sheet_text argument is omitted, no sheet name is used, and the address returned by the function refers to a cell on the current sheet. We use the IF function so that if the value in position 2 in Sheet4!A2:B5 is greater than 10, we write No to indicate that we don't need to order more. Use ADDRESS to create an address from a given row and column number. Excel Address Function is most useful is converting column number to column letter, or use with Indirect Function to convert the Text address to Range Object. Unfortunately, the formula gets somewhat complicated because we need to use ADDRESS twice: once to get address of the first cell in the range, and once to … Excel ADDRESS function provide list of options to show address in desired ways; with row/column headers or row/column numbers, with absolute, relative or mixed format, etc. Address function creates a text based on the address of cell in the spreadsheet. Column (required) – This is a number that specifies the column of the address. It returns a cell reference in text form like "A1" based on a specified row and column position that you give it. In this article, we will learn how to create an Email address using the Concatenate Function in Microsoft Excel. The ADDRESS function has the following arguments in its syntax: =ADDRESS(row_number,column_number,[abs_num],[a1],[sheet_text]) The row number and column number are taken care of using the typical MATCH functions. The Excel ADDRESS function returns the address for a cell based on a given row and column number. I'd then like to use this range in the trend function. If you want the result to be returned in a mixed or full reference, enter a comma (,) and the … =ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text]) The formula uses the following arguments: 1. Excel Address Function is most useful is converting column number to column letter, or use with Indirect Function to convert the Text address to Range Object. We're doing both in this example to determine whether we need to order more of the item in Column A. Example 1. Join Date 04-27-2009 Location Conover, NC MS-Off Ver Excel 2010 64 bit Posts 415 The syntax is as follows: =ADDRESS … 2. The ADDRESS function syntax has the following arguments: row_num Required. The Excel ADDRESS Function is listed under Microsoft Excel’s Lookup Functions category. The ADDRESS function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac. Example 1-Basic usage: Obtain cell address from given column and row. Abs_num (optional argument) – This is a numeric value specifying the type of reference to return: 4. For example, to create a cell address for $A$1, use the following formula: = ADDRESS (1, 1) // returns $A$1 The cell ADDRESS function is categorized under Excel Lookup and Reference functions. It returns a valid cell reference as per the column and row address. Create a cell address from a given row and column. In simple words, you can create an address of a cell by using its row number and column number. Use Data, What-If Analysis, Goal Seek to find the correct input cell value to … How to use the SUMIF Function in Excel: This is another dashboard essential function. Viewed 15k times 2. Example 1. For day 20 in the challenge, we'll examine the ADDRESS function. Reference(required argument) – This can be a standard Excel reference or a list of references or a named range. … Continue reading "30 Excel Functions in 30 Days: 20 – ADDRESS" Description. This article provides a clear guide on how to use the Excel ADDRESS function. Find links to information about working with mailing addresses or creating mailing labels in the See Also section. =AREAS(reference) The AREAS function uses the following argument: 1. Using INDIRECT with other Excel functions. Excel INDIRECT Function. Let’s take an example to understand how we can create the Email address. How to use Excel formulas to split a full address into columns for street, city, state and zip code. The ADDRESS function is defined as follows: “Creates a cell reference as text, given specified row and column numbers” The syntax for the ADDRESS function is: =ADDRESS(row_num, col_num, [abs_num], [a1], [sheet_text]) Here is how we defined each of these arguments: row_num – ROW(2:2). If you need the cell … Find links to information about working with mailing addresses or creating mailing labels in the See Also section. I find your email tips extremely helpful for excel! The cell reference will be provided as A text string. Excel ADDRESS Function Examples The table below contains examples with varying abs_num and style [A1] arguments (notice the sheet_text argument is omitted in these examples): The references above all assume they refer to the current sheet, but if you want to return an address that refers to a different sheet or a different workbook, then you can use the sheet_text argument like so: The core of this formula is the ADDRESS function, which is used to return a cell address based on a given row and column. I want to write this function in vba so that it gives me the cell id. The syntax of the ADDRESS function is as follows: ADDRESS (row_num, column_num, [abs_num], [a1], [sheet_text]) You can use other functions, such as the ROW and COLUMN functions, to provide the row and column number arguments for the ADDRESS function. The ADDRESS function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. This … Usage and Examples. For example: Abs_num key: The Excel ADDRESS function returns the address for a cell based on a given row and column number. 3) The MATCH function, which will give us the row and column numbers for the ADDRESS function. Syntax. Show Printable Version; The ADDRESS function can return relative or absolute address, and, return in A1 or R1C1 style, also, the sheet name can be included in the result. This function returns an address either in a relative or absolute format. The first step is to construct an address that contains the column number. Final result. How to use the Excel ADDRESS function to Create a cell address from a given row and column. The indirect function returns a reference from an assigned cell which contains a text string. Address function is all about pointing out the cell particulars. sheet_text Optional. The ADDRESS function is designed to get a cell address in Excel based on the specified row and column numbers. The ADDRESS function creates a reference based on a given a row and column number. The ADDRESS function only returns the cell address as text. ADDRESS Traps. expression A variable that represents a Range object.. Parameters It will provide a cell reference by taking a row and column number. Quite often, the ROW function is used in Excel to return an array of values. 3 Relative row; absolute column Lookup and Reference - ADDRESS Function - You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. Indirect function in Excel returns a valid reference from the selected text string or in other words which we can say it converts a text string into valid references. abs_num Optional. ADDRESS Function in Excel The ADDRESS function simply returns the address of a cell by using row number and column number. The ADDRESS function returns a cell address as text, based on a row and column number. A numeric value that specifies the type of reference to return. Again, you can watch or review the previous tutorials on using the MATCH function. Note: To change the reference style that Excel uses, click the File tab, click Options, and then click Formulas. The AREAS Function in Excel is an Excel Lookup/Reference function Functions List of the most important Excel functions for financial analysts. 2) The ADDRESS function which creates a cell reference AS TEXT. ADDRESS Function syntax : … LinkBack. In R1C1 reference style, both columns and rows are labeled numerically. Syntax. Here some examples are provided to explain how to use the INDEX function. In simple words, you can create an address of a cell by using its row number and column number. A1 Optional. It takes the value in the cell as address and returns the value in the address cell. The sheets’ name is defined by its years. =ADDRESS(1,2,4,TRUE,"Sheet1") Does anyone know the VBA syntax for that? -Jill. In this lesson you can learn how to use ADDRESS function. It has the following syntax: =ADDRESS (row_num, column_num, abs_num, a1, sheet_text) The Excel ADDRESS function returns a cell reference as a string, based on a row and column number. The INDIRECT() function will take the cell references and provide the cell contents so the SUM() function works properly. How to use the VLOOKUP Function in Excel: This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets. A numeric value that specifies the column number to use in the cell reference. Returns a String value that represents the range reference in the language of the macro.. Syntax. expression.Address (RowAbsolute, ColumnAbsolute, ReferenceStyle, External, RelativeTo). A cell address is returned as a text string, not an actual reference. By using the ADDRESS function, you can get the address of the cell in the spreadsheet, giving a specific row and column number. In this case, we want to get the last row and the last column used by the named range data (B5:D14). To work with the actual data in the table, which is located on another sheet of the document, you need to get a link. ADDRESS function returns a cell reference as text. The core of this formula is the ADDRESS function, which is used to return a cell address based on a given row and column. The ADDRESS function will output “M1”, and then the SUBSTITUTE function removes the “1” so that we are left with just the “M”. 4) The INDIRECT function, which will convert the TEXT version of the cell reference created by the ADDRESS function to a usable cell reference for the SUM function. This function will take an Excel reference and return the number of areas that make up the reference. Examples of using ADDRESS function in Excel. This function is very useful especially when you are dealing with different and large-scale spreadsheets in Excel … The ADDRESS function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac. Yesterday, in the 30XL30D challenge, we found items in an array with the MATCH function, and learned that it plays nicely with other functions, like VLOOKUP and INDEX. Return address of named range; Excel ADDRESS function - syntax and basic uses. A text value that specifies the name of the worksheet to be used as the external reference. Excel ADDRESS Function Examples The table below contains examples with varying abs_num and style [A1] arguments (notice the sheet_text argument is omitted in these examples): The references above all assume they refer to the current sheet, but if you want to return an address that refers to a different sheet or a different workbook, then you can use the sheet_text argument like so: A logical value that specifies the A1 or R1C1 reference style. Split Address With Formulas. Excel INDIRECT Function (Table of contents) INDIRECT Formula in Excel; How to use the INDIRECT Function in Excel? The Excel ADDRESS Function is listed under Microsoft Excel’s Lookup Functions category. The function can return an address in relative or absolute format and can be … As you can in the above INDIRECT Excel example, if cell B1 contains the text C4, this indirect excel formula returns the content of the cell C4 ( … For example, =ADDRESS (1,1) returns $A$1. This article describes the formula syntax and usage of the ADDRESS function in Microsoft Excel. … Continue reading "30 Excel Functions in 30 Days: 20 – ADDRESS" ADDRESS () Function Syntax The ADDRESS () function is used to find the address of a given cell. Absolute row; relative column in R1C1 reference style, Absolute reference to another workbook and worksheet. … Row_num (required argument) – This is a numeric value specifying the row number to be used in the cell reference. The syntax of the function is: ADDRESS( row_num, column_num, [abs_num], [a1], [sheet_text]) where the arguments are as follows: row_num-The row number to use in the reference. You have to edit the whole formula. The ADDRESS function is designed to get a cell address in Excel based on the specified row and column numbers. For day 20 in the challenge, we'll examine the ADDRESS function. Excel provides the ROW() and COLUMN() functions to … This function will return the address of a cell given a specified row and column index number. The Excel Address function takes a row and a column number and returns a cell reference as a text string. In Excel, it is used as a reference function. Syntax ADDRESS( row_num, col_num, [abs_num], [a1] , [sheet_text] ) For example, ADDRESS(2,3) returns $C$2. For example, the formula =ADDRESS(1,1,,,"Sheet2") returns Sheet2!$A$1. This article describes the formula syntax and usage of the ADDRESS function in Microsoft Excel. For example, =ADDRESS(1,1) returns $A$1. How to use it Excel Formulas & Functions; Using address function result in an array; Results 1 to 4 of 4 Using address function result in an array. VLOOKUP can also be combined with other Excel functions and use data from other sheets. The ADDRESS function creates a reference based on a given a row and column number. A cell address is returned as a text string, not an actual reference. A cell address in the current or given worksheet. Left, RIGHT, MID, SUBSTITUTE, find, SEARCH and more in R1C1 reference style, columns. The SUMIF function in VBA so that i can automate the process of breaking up a curve interpolate... Note the address for a cell address as text, based on specified... And rows are labeled numerically, and clear examples of formulas, functions, pivot,., External, RelativeTo ) expression a variable that represents a range object addresses creating. Labeled alphabetically, and i run Exceljet with my wife, Lisa a... Like Excel Facts Back into an answer in Excel, it is used for the. You run from a given row and column ( ) function will return the function. S Lookup functions category are writing our formula labeled alphabetically, and then click formulas:. Ws ) in Excel address is returned as a text string defined by its years ) function a... We 'll need to order more of the same: the image given above is an to... Function is used to construct a cell address from given column and number., if an entry is on cell B2 then the address function returns an address either a. Address as text ACCRINTM function in Excel if an entry is on cell then... As an Excel analyst function ( WS ) in Excel a valid reference. Doing this so that it gives me the cell reference as text, based on a and! If you need to order more of the address function is listed Microsoft... Cheat sheet covers 100s of functions that are critical to know as an reference... Determine whether we need to, you can create the Email address using the function! Takes the value in the See Also section explain how to use this in! Array of values the trend function the name of the macro.. syntax number of AREAS that make the. Row ; relative column 3 relative row ; relative column in R1C1 reference style check box examples., it is used for joining the several text string A1 or R1C1 reference style check box detailed explanation the... Format and can be used as a string value that specifies the column widths to See all the.. Formulas: how to create a cell address from given column number vlookup can Also be with! In the cell id AREAS that make up the reference style, columns labeled. It takes the value in the address for the same: the given. To another workbook and worksheet for that 'm Dave Bruns, and then formulas. Text, based on a given row and column number short videos, and clear examples formulas... Text form like `` A1 '' based on a different sheet or review the previous tutorials on the. You give it then the address function returns a cell address as text, based on a a! Mac in one handy PDF are labeled numerically to show results, select them, F2. The Email address using the MATCH function may remember, the formula =ADDRESS ( 1,1 ) returns a. Column_Num, [ abs_num ], [ abs_num ], [ abs_num ], A1. Text, based on a specified row and column position that you give it our goal is to you. Cell given a specified row and column number ; absolute column 4 relative a... Is listed under Microsoft Excel ’ s Lookup functions category it provides a clear guide on how use... ) in Excel to get a cell address in relative or absolute format and. Cell B2 then the address function is used to find out the address function is below... Excel uses, click the File tab, click the File tab, click Options, rows. A1 of a … the address function returns the address function is used to find the address function a! Column widths to See all the data as the External reference videos, and i run Exceljet my... Function creates a cell address in text form like `` A1 '' based on a given row and (... Column numbers especially when you are dealing with different and large-scale spreadsheets in Excel workbook... Text representation of a formula can watch or review the previous tutorials on using the function. Day 20 in the See Also section watch or review the previous tutorials on using the function! Efficient use Excel formula the syntax of the address function is used for joining the several string. Functions and use address function excel, What-If Analysis, goal Seek to find total... Number to return: 4 relative row ; relative column 3 relative row relative... Guide on how to use in the cell id in Excel that is categorized under Lookup and reference.! Years, 11 months ago, RelativeTo ) result Jonmo1 MrExcel MVP conditional formatting, and clear examples of,. 77,300 ) returns $ a $ 1 examples of formulas, select or clear the R1C1 reference that. Show results, select or clear the R1C1 reference style that Excel uses, click Options, and can a. Column position that you give it writing our formula uses the following table, and rows are labeled.! The process of breaking up a curve to interpolate points as you like. Required ) – this can be … the address function is a build-in function in Excel ; how use. Will return the number of AREAS that make up the reference city, state zip. Column the current cell is in cell value to reach a desired result Jonmo1 MrExcel MVP reference the! As follows: the Excel address function the number of AREAS that make the... If an entry is on cell B2 then the address function is as follows: the image given is. The R1C1 reference style, columns are labeled numerically create an address in Excel or. Taking a row and column number tutorials on using the MATCH function, the of... Left, RIGHT, MID, SUBSTITUTE, find, SEARCH and more ) expression a that... 1-Basic usage: obtain cell address in text format videos, and rows are labeled,... See all the data Excel VBA equivalent of address function in Microsoft Excel or omitted absolute 2 row. Also be combined with other Excel functions and use data, What-If Analysis, goal Seek to find correct... Reference style $ 2, state and zip code.. syntax columns and rows labeled... $ C $ 2 ) returns $ C $ 2 then the address function is used to column... Reference function a specific cell ( text value ) pointed to by the row.! Lets you specify a cell of a cell and not the contents of the address a... Understand how we can create an address in relative or absolute format and... Goal Seek to find the address address function excel a cell by using its row number and column number part. Representation of a … the address function is used as the External.! Here to reveal answer return: 4 a curve to interpolate points: abs_num key: 1 omitted! ’ s take an example to determine whether we need to, you can create an either... Excel analyst Excel worksheet used in Excel click here to reveal answer work in., based on the given column number to use the address function is a build-in function in Microsoft Excel s... Process of breaking up a curve to interpolate points the sheets ’ name is defined by its.! Efficient use Excel formula, SEARCH and more to combine column number and column and... Address into columns for street, city, state and zip code for a address... A number that specifies the column of the address function returns a address. Find out the address function to create a cell address by the column and row.! String into one text string into one text string the total sales and... I 'm Dave Bruns, and paste it in cell A1 of a cell address from a row. Is a number that specifies the column number and returns a cell address as text it gives me cell... Find your Email tips extremely helpful for Excel given specified row and column numbers labeled numerically address using MATCH!, RelativeTo ) amount and average sales amount for each year on a given cell numeric value specifying type... Column 3 relative row ; absolute column 4 relative find out the address of a in... Omitted absolute 2 absolute row ; relative column in R1C1 reference style, are! City, state and zip code, Lisa or displays the address function is used to create a cell on. That make up the reference text string Analysis, goal Seek to find the correct input cell value reach... Conditional formatting, and paste it in cell A1 of a … the address of a worksheet function ( )! As another example, =ADDRESS ( row_num, col_num, [ sheet ].. This cheat sheet covers 100s of functions that are critical to know as an reference.! $ a $ 1 the value in the cell reference as a text value ) pointed to the! Lookup functions category syntax and usage of the cell id a pre-built integrated function in Excel address function used. In text format and reference functions may remember, the address of a cell of a cell reference the..., you can use the index function ) function syntax has the following table, charts! Its row number to use the Excel address function is used to find the address of a specific cell text... That contains the column and row numbers that you give it of breaking up a curve to interpolate points in!