=b(??) help

[tezza]

Hi all

To make a cell = another cell you simply do =b1, but how do you split the b1 bit.

Lets say j1 - j10 has 1 to 10 and b1 - b10 has text for a simple example.

How do you make d1 - d10 do =b(j1) to =b(j10) ?

So as j5 would have 5 in the cell, d5 would show ColB at location J5, hence =b(J5)

Can you split it like that? If not, how would you go about doing it?

Regards

 

[VoG]

Try

=INDIRECT("B"&J5)

 

[tezza]

Try

=INDIRECT("B"&J5)

Quick response, thank you.

Could I also use that formula to add a numerical value to J5?

=INDIRECT("B"&J5+10) ?? which in turn would be =B15

 

[VoG]

Yes.

 

[Scott Huish]

=index(b:b,j5+10)

 

[T. Valko]

Hi all

To make a cell = another cell you simply do =b1, but how do you split the b1 bit.

Lets say j1 - j10 has 1 to 10 and b1 - b10 has text for a simple example.

How do you make d1 - d10 do =b(j1) to =b(j10) ?

So as j5 would have 5 in the cell, d5 would show ColB at location J5, hence =b(J5)

Can you split it like that? If not, how would you go about doing it?

Regards

Another way...

J5 = 5

=INDEX(B:B,J5)

That will return whatever is in cell B5.

 

[tezza]

Thank you.