| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using the value of one cell to refer to another cell
I would like to use the value of one cell, to be able to refer to a cell
reference. For instance: the value of aa3 = 40 I would like to use that value as part of a cell reference: b((aa3+3) Naturally, Excel isn't letting me do that - but is there a way? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the value of one cell to refer to another cell
=INDIRECT("B"&AA3+3) "Jim in Australia" wrote: I would like to use the value of one cell, to be able to refer to a cell reference. For instance: the value of aa3 = 40 I would like to use that value as part of a cell reference: b((aa3+3) Naturally, Excel isn't letting me do that - but is there a way? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the value of one cell to refer to another cell
Try with INDIRECT()
=INDIRECT("B" & AA3+3) the above will refer cell B43 if AA3 is 40 If this post helps click Yes --------------- Jacob Skaria "Jim in Australia" wrote: I would like to use the value of one cell, to be able to refer to a cell reference. For instance: the value of aa3 = 40 I would like to use that value as part of a cell reference: b((aa3+3) Naturally, Excel isn't letting me do that - but is there a way? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refer to a sheet using a cell value | Excel Worksheet Functions | |||
| refer to the cell as it is empty... | Excel Discussion (Misc queries) | |||
| How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
| How to refer the results of one cell to another cell? | Excel Discussion (Misc queries) | |||
| How to refer to every 5 th cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
