Cell reference: a cell picks up the location to go to from another cell

[Heidelbond]

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

 

[drsarao]

Welcome to MrExcel

=INDIRECT("AL" & BX5) should do it.