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..
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 65"]
<!--StartFragment--> <colgroup><col width="65" style="width:65pt"> </colgroup><tbody>[TR]
[TD="width: 65, align: right"]A[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]andrew[/TD]
[TD]=B1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]roger[/TD]
[TD]=B3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]bob
[/TD]
[TD]=B15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]ted[/TD]
[TD]=B7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]pete[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.