Formula - Adjustable Column Reference

M

mdalby

There isa command to allow a formula to refer to a number in a cell to
adjust the column that is used in the formula. BUT I CAN"T FIND IT!

If I want the formula to be using cell A11, I want to have 11 in a cell
and have it refer to whatever to A11. If I have 12 in the cell then I
want it to refer to A12 instead. Sorry, I am not explaining the
scenario very well.

Help.

MD
 
B

Bob Phillips

=INDIRECT("A"&A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top