| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to make a flexible cell reference?
Does anyone know how to make a reference to a cell flexible. I.e. I want a
formula to get data from a cell, but want the cell to be dependant on some other value. E.g. =C"x+1" where "x+1" is a column number dependant on the value of x. I sure hope anyone can help me with this! Mark |
|
#3
|
|||
|
|||
|
Is x a cell on a worksheet?
If yes, then maybe you want something like: =INDIRECT("C"&A1) or =INDIRECT("C"&A1+1) Mar Vernooy wrote: Does anyone know how to make a reference to a cell flexible. I.e. I want a formula to get data from a cell, but want the cell to be dependant on some other value. E.g. =C"x+1" where "x+1" is a column number dependant on the value of x. I sure hope anyone can help me with this! Mark -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
