Cell Reference Question

[hevner]

Hello,

I am trying to reference the value of one cell related to the value of
another.

Example. Cell A1 has the value 6. Cell B6 contains the value 0.25

I want a new cell, say C1, to contain the value in column B, and the
row corresponding to the number in A1. Since cell A1 contains the
number "6". I want to refer to cell B"6" and put that value in C1.

I unsuccessfully attempted the following.

C1 = value(B(Value(A1)))

Thanks,

 

[cmoore]

put this in cell C1 to get the value 0.25

=INDIRECT("b"&A1)

 

[Anders S]

=INDIRECT("B"&A1)

HTH
Anders Silvén

 

[Aladin Akyurek]

=INDEX(B:B,A1)

 

[hevner]

Thanks to everyone that replied.

They all worked