Cell reference dependency
 

Hi All
Is it possible to define a cell through a data input:

Example:
A1 is valued '145'
Then shown in A2 should be value from: C145

A1 is valued '250'
Then shown in A2 should be value from: C250

THANKS so much in advance...


--
Jubelnar
------------------------------------------------------------------------
Jubelnar's Profile: http://www.excelforum.com/member.php...o&userid=10517
View this thread: http://www.excelforum.com/showthread...hreadid=470732

Cell reference dependency
 

in cell A2, enter:
=indirect("C"&A1)
Rob

"Jubelnar" wrote:


Hi All
Is it possible to define a cell through a data input:

Example:
A1 is valued '145'
Then shown in A2 should be value from: C145

A1 is valued '250'
Then shown in A2 should be value from: C250

THANKS so much in advance...


--
Jubelnar
------------------------------------------------------------------------
Jubelnar's Profile: http://www.excelforum.com/member.php...o&userid=10517
View this thread: http://www.excelforum.com/showthread...hreadid=470732

Cell reference dependency
 

Try something like this:

A2: =INDIRECT("C"&A1)

Does that help?

Regards,
Ro

--
Ron Coderr
-----------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...fo&userid=2141
View this thread: http://www.excelforum.com/showthread.php?threadid=47073

Cell reference dependency
 

Thanks!!!!


--
Jubelnar
------------------------------------------------------------------------
Jubelnar's Profile: http://www.excelforum.com/member.php...o&userid=10517
View this thread: http://www.excelforum.com/showthread...hreadid=470732