Hello,

Could somebody please tell me how to get the following information.

I would like one row to be dependent on another row and to make the
dependency cariable.

for example

In cell G10 I have specified that I want row 10 to be dependent on row 2 by
entering the value "2". This value can and will change throughout my project
as row ten will be dependent on different rows at different times.

In cell H10 I want a formula that looks at the dependency row in cell G10
(in this case row 2) and therefore adds the values in B2 and C2.

I think I have to use a combination of ADDRESS and MATCH but am really not
clear how to go about it.

Any help appreciated!

Ellebelle

=INDIRECT("B"&G10)+INDIRECT("C"&G10)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ellebelle" wrote in message
...
Hello,

Could somebody please tell me how to get the following information.

I would like one row to be dependent on another row and to make the
dependency cariable.

for example

In cell G10 I have specified that I want row 10 to be dependent on row 2
by
entering the value "2". This value can and will change throughout my
project
as row ten will be dependent on different rows at different times.

In cell H10 I want a formula that looks at the dependency row in cell G10
(in this case row 2) and therefore adds the values in B2 and C2.

I think I have to use a combination of ADDRESS and MATCH but am really not
clear how to go about it.

Any help appreciated!

Ellebelle

thank you!

"Bob Phillips" wrote:

=INDIRECT("B"&G10)+INDIRECT("C"&G10)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ellebelle" wrote in message
...
Hello,

Could somebody please tell me how to get the following information.

I would like one row to be dependent on another row and to make the
dependency cariable.

for example

In cell G10 I have specified that I want row 10 to be dependent on row 2
by
entering the value "2". This value can and will change throughout my
project
as row ten will be dependent on different rows at different times.

In cell H10 I want a formula that looks at the dependency row in cell G10
(in this case row 2) and therefore adds the values in B2 and C2.

I think I have to use a combination of ADDRESS and MATCH but am really not
clear how to go about it.

Any help appreciated!

Ellebelle