Variable Referencing cells?

[cpg39]

I'm sorry, really couldn't think of how to phrase this question but here it goes:

So we all know you can have a formula reference another cell, so for ex: =c4*d5

But what I really want to accomplish is the following: =c(a1)*d5


to clarify, this would mean that if a1 contained the value "1", then the formula would function like: =c1*d5



Is this possible? It would be very helpful if I could pull it off somehow.

Thanks for all the help on my first post,

Colin

 

[Tetra201]

Try this:

=INDEX(C:C,A1)*D5

 

[Norie]

Colin

INDEX is probably the best solution for your specific example but you could also consider INDIRECT.

=INDIRECT("C" & A1)*D5

 

[cpg39]

That works perfectly. Thanks for the speedy and simple response. Have a great night.

-Colin