Cell row to be dependent upon value in another cell
 

Hi
I'm pretty new to Excel, and need help. I am trying to define a cell that is
in column C, and whose row value is determined by reference to another cell.
For example:

C(($B$1)+5) would define the row to be the value given by the number in
$B$1, with 5 added to it.

I don't know if what I am trying to do is possible. If it is not, could
someone suggest another way?

Thanks!
--
C.MacDonald

Cell row to be dependent upon value in another cell
 

Thanks Elkar. I don't think that will work. I am trying to use the cell in an
equation, such as:

c7*c(($B$1)+5)

Any ideas how to accomplish this?

Thanks!
--
C.MacDonald


"Elkar" wrote:

Try the INDIRECT function:

=INDIRECT("C" & $B$1 + 5)

HTH
Elkar


"C. MacDonald" wrote:

Hi
I'm pretty new to Excel, and need help. I am trying to define a cell that is
in column C, and whose row value is determined by reference to another cell.
For example:

C(($B$1)+5) would define the row to be the value given by the number in
$B$1, with 5 added to it.

I don't know if what I am trying to do is possible. If it is not, could
someone suggest another way?

Thanks!
--
C.MacDonald

Cell row to be dependent upon value in another cell
 

Elkar, thanks a lot! I finally got it to work. Much appreciated!
--
C.MacDonald


"Elkar" wrote:

It should work:

=C7*INDIRECT("C"&$B$1+5)



"C. MacDonald" wrote:

Thanks Elkar. I don't think that will work. I am trying to use the cell in an
equation, such as:

c7*c(($B$1)+5)

Any ideas how to accomplish this?

Thanks!
--
C.MacDonald


"Elkar" wrote:

Try the INDIRECT function:

=INDIRECT("C" & $B$1 + 5)

HTH
Elkar


"C. MacDonald" wrote:

Hi
I'm pretty new to Excel, and need help. I am trying to define a cell that is
in column C, and whose row value is determined by reference to another cell.
For example:

C(($B$1)+5) would define the row to be the value given by the number in
$B$1, with 5 added to it.

I don't know if what I am trying to do is possible. If it is not, could
someone suggest another way?

Thanks!
--
C.MacDonald

Cell row to be dependent upon value in another cell
 

It should work:

=C7*INDIRECT("C"&$B$1+5)



"C. MacDonald" wrote:

Thanks Elkar. I don't think that will work. I am trying to use the cell in an
equation, such as:

c7*c(($B$1)+5)

Any ideas how to accomplish this?

Thanks!
--
C.MacDonald


"Elkar" wrote:

Try the INDIRECT function:

=INDIRECT("C" & $B$1 + 5)

HTH
Elkar


"C. MacDonald" wrote:

Hi
I'm pretty new to Excel, and need help. I am trying to define a cell that is
in column C, and whose row value is determined by reference to another cell.
For example:

C(($B$1)+5) would define the row to be the value given by the number in
$B$1, with 5 added to it.

I don't know if what I am trying to do is possible. If it is not, could
someone suggest another way?

Thanks!
--
C.MacDonald