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

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

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