dynamic reference to cell??
 

If I have values in cells A1:B2 for example
1,2
3,4

In A4, I'd like to be able to type the cell, and have B4 populate with the
value in the cell. So if in A4 I type 'A2', the number 3 would populate in
B4. Likewise, if in A4 I change the entry and type 'B2', I want the number 4
to populate in B4.

Does that make sense???

dynamic reference to cell??
 

It makes sense. There is a function just for you:

=INDIRECT(A4)
--
Gary's Student
gsnu200705


"mfrey" wrote:

If I have values in cells A1:B2 for example
1,2
3,4

In A4, I'd like to be able to type the cell, and have B4 populate with the
value in the cell. So if in A4 I type 'A2', the number 3 would populate in
B4. Likewise, if in A4 I change the entry and type 'B2', I want the number 4
to populate in B4.

Does that make sense???

dynamic reference to cell??
 

WOW, that was too easy!
you rock, thanks!

"Gary''s Student" wrote:

It makes sense. There is a function just for you:

=INDIRECT(A4)
--
Gary's Student
gsnu200705


"mfrey" wrote:

If I have values in cells A1:B2 for example
1,2
3,4

In A4, I'd like to be able to type the cell, and have B4 populate with the
value in the cell. So if in A4 I type 'A2', the number 3 would populate in
B4. Likewise, if in A4 I change the entry and type 'B2', I want the number 4
to populate in B4.

Does that make sense???

dynamic reference to cell??
 

Excel rocks, I just roll.
--
Gary's Student
gsnu200705


"mfrey" wrote:

WOW, that was too easy!
you rock, thanks!

"Gary''s Student" wrote:

It makes sense. There is a function just for you:

=INDIRECT(A4)
--
Gary's Student
gsnu200705


"mfrey" wrote:

If I have values in cells A1:B2 for example
1,2
3,4

In A4, I'd like to be able to type the cell, and have B4 populate with the
value in the cell. So if in A4 I type 'A2', the number 3 would populate in
B4. Likewise, if in A4 I change the entry and type 'B2', I want the number 4
to populate in B4.

Does that make sense???