Pass row number as variable in excel sheet

Use this best solution :

By using INDIRECT and considering row number is in B1,

=INDIRECT("A" & B1)

    It will get a cell reference as a string here, concatenation of A and the value of B1 – 5, and returns the value to the cell.

Try this easiest solution :

B1 =ROW(A5)

Use this below link to more information,
http://www.techonthenet.com/excel/formulas/row.php

Use this OFFSET method :

The column value is save in B1, and follow the below code,

C1 = OFFSET(A1, 0, B1 - 1)

Running this methods :

    a) Getting a base cell, that is A1.
    b) preservation it as A and adding 0 to the row.
    c) In the column  to adding ,A5 – 1.

In case want to modify the row value by using another value instead of 0.