Hi,

Is there a way to substitute a column letter in a formula, say the letter "C" for column C, with a reference to a cell containing that column letter?

Right now, I have the following formula:

=C17:INDEX(C:C,COUNTA(C:C))

I would like to link those C's to a cell containing either a number or a letter.

What I am trying to do is create a dynamic range with a column that may move left or right. Sometimes the dynamic range will be column C, sometimes another column. I am also trying to NOT use volatile function OFFSET which would work but slow things down.


Thanks,

Lawrence