cell value pointers

Question

Instead of a cell value that reads:

=B27

I would like to have a variable row number that references another cell.  I.e., instead of "27" as the row number, there would be a reference to a second cell that would contain the row number.  Thus, if the second cell contains 5, the first cell would have the equivalent value of  =B5.

Is that possible?

Thank you!

Answer 1

You may use Indirect function for it.

=INDIRECT("B"&B27)  where cell B27 contains 5.  It will fetch value of B5.