HELP!!!! Cell Value in a Cell Address
 

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


--
samccaskill
------------------------------------------------------------------------
samccaskill's Profile: http://www.excelforum.com/member.php...o&userid=27805
View this thread: http://www.excelforum.com/showthread...hreadid=473143

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 value
you choose--this would save having to modify the formula if you need to
change the subtraction value).

Does this work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473143

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
------------------------------------------------------------------------
samccaskill's Profile: http://www.excelforum.com/member.php...o&userid=27805
View this thread: http://www.excelforum.com/showthread...hreadid=473143

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

Thanks for your help!!!

Sam


--
samccaskill
------------------------------------------------------------------------
samccaskill's Profile: http://www.excelforum.com/member.php...o&userid=27805
View this thread: http://www.excelforum.com/showthread...hreadid=473143

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

Cheers!


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473143