HELP!!!! Cell Value in a Cell Address

[samccaskill]

HELP!!!

This may be a basic question, but it's giving me trouble.

I'm trying to set up a worksheet where by inputing a value in a cell,
it changes the value reference in another cell to a new
address.....(confused yet?)

Ex:

in A1, the person would input "24"
then, the value in B2 would equal the value in C24

if they put in "13" into A1, the value in B2 would equal the value in
C13

Does that make sense?

Also, can I use a simple equation in it....like subtraction

Ex:

in A1, the person would input "52"
then, the value in B2 would equal the value in C12, which is 52-40

in A1 the person would input "68"
then the value in B2 would equal the value in C28, which is 68-40

Thanks for your help everyone!!!

Sam

 

[swatsp0p]

Use the INDIRECT function, as such:

for your first question:

=INDIRECT("C"&A1,1)

for your second question

=INDIRECT("C"&(A1-40),1)

--OR--

=INDIRECT("C"&(A1-A2),1) where A2 holds the value 40 (or whatever valu
you choose--this would save having to modify the formula if you need t
change the subtraction value).

Does this work for you

 

[samccaskill]

The only change is that I think yours changes the column reference, and
I needed the row reference changed.

ie:

changing the value in A1 would give you a new value in B1

like A1=x, then B1=Cx

A1=14, B1=c14

Does that make sense?

There would be a huge list of values in column C, and by putting a
different number into A1, the value in B1 would then seek out the
corresponding C column value.

 

[samccaskill]

I dropped the "1" off the end and got it to work.

Thanks for your help!!!

Sa

 

[swatsp0p]

Glad you got it to work for you. Thanks for the feedback, it is alway
appreciated.

Cheers