Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm trying to reference a cell using other cells, for example: B(60-A30),
which is to mean reference the cell in the Bth column, and the (60-A30)th row. How do I do this in Excel 2000? |
#2
![]() |
|||
|
|||
![]()
I think you can use a command called Indirect.
eg if you had "B1" written in cell A1 you could do the following: =indirect(A1) and it would retrieve the contense of cell B1 You can also use concatenate formulas within the indirect to construct a cell refrence from two cells. eg if Cell C1 contained the number 3 =indirect(concatenate("A",C1)) would retrieve the contense of Cell A3 or you can combine two other cells to create a new reference "BraveFencerPawson" wrote: I'm trying to reference a cell using other cells, for example: B(60-A30), which is to mean reference the cell in the Bth column, and the (60-A30)th row. How do I do this in Excel 2000? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How do I use a variable in a cell reference? | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |