Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Referring to Cells in a forumula using a function
I want to be able to refer to a cell in a formula using a function. So
normally I would refer to a cell as R1C1 using RC type of reference. But say I want to refer to cell R1C(myFunction(R2C2)). myFunction(R2C2) would return a value which would specify which column the cell is in based on the contents of R2C2. So if the function returned "2", the I would get cell R1C2. Is this possible? Thanks LRL |
#2
|
|||
|
|||
Referring to Cells in a forumula using a function
Do you want the data from the R1C1 cell? If so, use
=INDIRECT("R1C1",FALSE) You could replace "R1C1" with "R1C"&myfunction(R2C2) "LRL" wrote in message ... I want to be able to refer to a cell in a formula using a function. So normally I would refer to a cell as R1C1 using RC type of reference. But say I want to refer to cell R1C(myFunction(R2C2)). myFunction(R2C2) would return a value which would specify which column the cell is in based on the contents of R2C2. So if the function returned "2", the I would get cell R1C2. Is this possible? Thanks LRL |
#3
|
|||
|
|||
Referring to Cells in a forumula using a function
Actually, it's a computed area that I want the data from not just one
particular cell. But this is exactly what I need. Thanks! "Barb Reinhardt" wrote: Do you want the data from the R1C1 cell? If so, use =INDIRECT("R1C1",FALSE) You could replace "R1C1" with "R1C"&myfunction(R2C2) "LRL" wrote in message ... I want to be able to refer to a cell in a formula using a function. So normally I would refer to a cell as R1C1 using RC type of reference. But say I want to refer to cell R1C(myFunction(R2C2)). myFunction(R2C2) would return a value which would specify which column the cell is in based on the contents of R2C2. So if the function returned "2", the I would get cell R1C2. Is this possible? Thanks LRL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
function to find which cells add up to a given total? | Excel Worksheet Functions | |||
Use TREND function with nonadjacent cells | Excel Worksheet Functions | |||
Conditionial formatting for merged cells, function Len($A$4) | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
i want to use the =if function to apply a colour to other cells | Excel Worksheet Functions |