Cell reference dependency

[Jubelnar]

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...

[Ron Coderre]

Try something like this:

A2: =INDIRECT("C"&A1)

Does that help?

Regards,
Ron

[Rob]

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
>
>

[Jubelnar]

Thanks!!!!