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

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

;)
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

drsarao

Well-known Member
Joined
Sep 9, 2009
Messages
1,112
Welcome to MrExcel

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

Watch MrExcel Video

Forum statistics

Threads
1,102,305
Messages
5,486,072
Members
407,532
Latest member
shahbazfcca

This Week's Hot Topics

Top