Create Live Reference

[Jacob]

I need to create a cell reference based on the current
value in another cell. For example, if the value in cell
B1 is "C", in another cell I need to create a reference
to "C4". If, however, B1 = "D", I need the reference to
be "D4". Any ideas?

Thanks!

 

[Frank Kabel]

Hi Jacob
try
=INDIRECT(B1 & "4")

 

[Charlie]

Jacob,

Try =if(B1="C",C4,D4)
or try =if(b1="C",C4,if(B1="D",D4,""))

Charlie O'Neill

 

[Frank Kabel]

Hi charlie
won't do as the OP wanted a cell reference