Solved Address in excel

July 17, 2011 at 07:42:20
Specs: Windows XP
Suppose I have some numbers in cells from A1 to A10.
If in another cell I write "=A5" it will show the value of A5 in it.
Now I want to write 5 in a cell ( say B1 ) and write something like =A(B1) in for example C1 to show the value of A5. and by changing B1, C1 changes.
What should I write?

See More: Address in excel

Report •

July 17, 2011 at 18:37:06
✔ Best Answer
Read up on the INDIRECT function in the Excel Help files.

There's an example that is almost exactly what you are looking for.

Learn by doing, I always...well, sometimes...say!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question