Value from another cell but...

[Cthulhu]

I want a cell to have a value that comes from another cell, but the cell from which it comes depends on what is in a 3rd cell. I'm not even sure this is possible

For example

Cells A1 = Hello, A2 = Bye
The value in cell C1 will come from a cell in the A col, but which cell exactly depends on the value in he cell B1
So if B1 = 1, C1 takes the value from A1 (Hello). Is B1 = 2, C1 = Bye. If B1 = 15, C1 takes its value in cell A15, and so on.

So is that possible? If so, how do i do that?

[Bob Phillips]

=INDIRECT("A""&B1)

--
HTH

Bob Phillips

"Cthulhu" <[email protected]> wrote in
message news:[email protected]...
>
> I want a cell to have a value that comes from another cell, but the cell
> from which it comes depends on what is in a 3rd cell. I'm not even sure
> this is possible
>
> For example
>
> Cells A1 = Hello, A2 = Bye
> The value in cell C1 will come from a cell in the A col, but which cell
> exactly depends on the value in he cell B1
> So if B1 = 1, C1 takes the value from A1 (Hello). Is B1 = 2, C1 = Bye.
> If B1 = 15, C1 takes its value in cell A15, and so on.
>
> So is that possible? If so, how do i do that?
>
>
> --
> Cthulhu
> ------------------------------------------------------------------------
> Cthulhu's Profile:
http://www.excelforum.com/member.php...o&userid=24848
> View this thread: http://www.excelforum.com/showthread...hreadid=383969
>

[Peo Sjoblom]

In C1 put

=INDEX(A:A,B1)


Regards,

Peo Sjoblom

"Cthulhu" wrote:

>
> I want a cell to have a value that comes from another cell, but the cell
> from which it comes depends on what is in a 3rd cell. I'm not even sure
> this is possible
>
> For example
>
> Cells A1 = Hello, A2 = Bye
> The value in cell C1 will come from a cell in the A col, but which cell
> exactly depends on the value in he cell B1
> So if B1 = 1, C1 takes the value from A1 (Hello). Is B1 = 2, C1 = Bye.
> If B1 = 15, C1 takes its value in cell A15, and so on.
>
> So is that possible? If so, how do i do that?
>
>
> --
> Cthulhu
> ------------------------------------------------------------------------
> Cthulhu's Profile: http://www.excelforum.com/member.php...o&userid=24848
> View this thread: http://www.excelforum.com/showthread...hreadid=383969
>
>

[Cthulhu]

Both ways work!
Thanks a lot for the help!