refer to cell from result???

[bridgerbell]

I have a column with numbers in it that are generated by a formula.
Let's say column B has the numbers: 2, 23, 10, 5, 1 going down the
rows. I want to take the results from that column and refer to cells
in another column. To clarify, given that set of numbers in column B,
I want to put references in column C to refer to: A2, A23, A10, A5, A1
using the results in column B. So, intuitively, the formula would look
something like =A(B1) etc.

If B1=2, I want C1 to show whatever's in A2.
If B2=23, I want C2 to show whatever's in A23
If B3=10, I want C3 to show whatever's in A10.

The numbers in column B are generated by a formula so they change.

What formula do I put in the cells of column C?

This seems like it should be so simple but I can't find it anywhere.
Please, if you even think you might now but it's not clear from what I
wrote, please email me: (e-mail address removed) . Thanks!

 

[Bernard Rey]

I think what you want is the INDIRECT function. In your case:

In C1: =INDIRECT("A" & B1)
In C2: =INDIRECT("A" & B2)
In C3: =INDIRECT("A" & B3)

Should give you the results you're expecting.


bridgerbell:

 

[bridgerbell]

That's it! I am most grateful for your help.

 

[JE McGimpsey]

I have a column with numbers in it that are generated by a formula.
Let's say column B has the numbers: 2, 23, 10, 5, 1 going down the
rows. I want to take the results from that column and refer to cells
in another column. To clarify, given that set of numbers in column B,
I want to put references in column C to refer to: A2, A23, A10, A5, A1
using the results in column B. So, intuitively, the formula would look
something like =A(B1) etc.

If B1=2, I want C1 to show whatever's in A2.
If B2=23, I want C2 to show whatever's in A23
If B3=10, I want C3 to show whatever's in A10.

The numbers in column B are generated by a formula so they change.

What formula do I put in the cells of column C?

Just as an alternative to the solution that Bernard gave:


C1: =INDEX(A:A,B1)

which you can copy down.