cell("row")得到当前公式行的行号 Column(A3)得到A3的相对列号，然后用Address求出上面两个函数得到的行列号的地址=$A$13这样的格式。最后再由Indirect引用上面这个地址的值。
cell("row")表示获取活动单元格的行号 column(A3)表示获取A3单元格的列好 Address表示取得第一个参数行第二个参数列单元格的地址 indirect表示获取其参数表示的单元格的值 你的公式有个问题就是column后面多了个空格，需要去掉
This function will search for the value fromrow number 7andcolumn number 3which isJohnsonand brings it here. We putFALSEbecause we are using theR1C1style here. Read More:How to Use Variable Row Number as Cell Reference in Excel Method 4 – Reference Cell by Row and Column Number Applying...
=ADDRESS(1,1)- returns the address of the first cell (i.e. the cell at the intersection of the first row and first column) as an absolute cell reference $A$1. =ADDRESS(1,1,4)- returns the address of the first cell as a relative cell reference A1. In the following table, you ...
How to Refer to a Cell in an Excel Formula?You refer to a cell in an Excel formula using a cell reference. A cell reference is the address of a cell.There are 3 types of cell references:Relative Cell Reference: In relative cell referencing, both the column and row change when you ...
The formula looks through the range “A1:J10”, checks the cell in Row 3 and Column 5 (“E3”) and returns its value (“Success”). Get Cell Value With the INDIRECT Function Another option for getting the value of a cell by its address is to use theINDIRECT Function. ...
The ADDRESS function obtains the cell address by the row and column numbers you specify, respectively. Please remember the order: first - row, second - column. In our formula, we supply the coordinates in the reverse order, and this is what actually does the trick! In other words, this ...
Let’s take an example to understand to add a cell, row or a column in Microsoft Excel. We have data in range A1: C15. Column A contains agent name, column B contains city, column C contains sales amount. Add Cell in data Follow below given steps:- ...
In the "Reference" field of the dialog box, type the address of the cell to which you want to navigate. The address of a cell is the combination of its column letter and row number. For example, if you want to go to the cell in column B and row 5, you would type "B5". ...
After that, in the ADDRESS function, you have the number returned by the MATCH (in the first argument), which is the ROW argument to define the row number. And in the second argument, we have the column number. Row 5 and Column 1 create a cell address A5....