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???
|