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