Excel: Get column Value based on anther column Val

Question

I have a row which contains a number: example A1 = 10 Now I want to get the value of Row B10, but the Row here is B(Value of A1). i need some thing like =B(A1)) so this value will = value of Column B but the row is based on value of A1

Answer 1

As commented, you can use INDIRECT

=INDIRECT("B"&A1)

Answer 2

use indirect:

=INDIRECT("B" & A1)