Heidelbond
New Member
- Joined
- Dec 18, 2009
- Messages
- 1
Suppose I wish obtain a value from a cell, say AL4. At a later point, I wish it to refer to another number, say AL20. I specify these numbers in another cell, say BX5.
In other words, the number after AL can vary, based on what I place into BX5.
I'm inclined to write: =+AL(BX5), but this won't be accepted by Excel
How do I have the formula except variable numbers after the alphabetic column letters (numbers that I can manually change from another cell)?

In other words, the number after AL can vary, based on what I place into BX5.
I'm inclined to write: =+AL(BX5), but this won't be accepted by Excel
How do I have the formula except variable numbers after the alphabetic column letters (numbers that I can manually change from another cell)?
