Cell refererence

[pedram]

Hi All this is my problem:
I would like to make a cell reference variable depending on another cell.
So if i write in cell C1 =B(A1) it equals cell B1
I want C2 cell to look into column B and use the row that A2 indicates ( so it will be B3).

If i change A1 from 1 to 88 i would want C1 to have the formula =B88..

A <!--StartFragment--> <colgroup><col width="65" style="width:65pt"> </colgroup><tbody> </tbody>	B	C
1	andrew	=B1
3	roger	=B3
5	bob	=B15
7	ted	=B7
	pete

<tbody>
</tbody>

THanks for you help

 

[Smitty]

Sounds like you're looking for INDIRECT:

Excel 2012
	A	B	C
1	1	andrew	andrew
2	3	roger	bob
3	5	bob	pete
4	7	ted	0
5	5	pete	pete
Sheet1

Cell Formulas
Range	Formula
C1	=INDIRECT("B"&A1)
C2	=INDIRECT("B"&A2)
C3	=INDIRECT("B"&A3)
C4	=INDIRECT("B"&A4)
C5	=INDIRECT("B"&A5)

HTH,

 

[shadow12345]

Sounds like you want to use something like indirect maybe?


the below into c1 and copied down would work.

=INDIRECT("b" & A1,TRUE)

*** Edit *** Too slow but I learnt you don't need the True then, I though you did to specify the A1 style rather than r1c1 but i learnt something.

 

[JoeMo]

in C1: =INDIRECT("B"&A1)

 

[pedram]

Thank you all. I have now learnt about indirect.