dynamic reference to cell??

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can a cell be turned on or off? 1
result of formula posted in different cell 2
Enter data into a cell that already has a function. 2
How to look up 2 Cell Values 9
Cell referencing 10
Lookup / Summary Table 8
Comparison of columns using Conditional Formatting 3
Populate a combo Box 1

Top