Pass row number as variable in excel sheet

Pass row number as variable in excel sheet

Asked on January 11, 2019 in Excel.
Add Comment


  • 3 Answer(s)

    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.

    Answered on January 11, 2019.
    Add Comment

    Try this easiest solution :

    B1 =ROW(A5)
    

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

    Answered on January 11, 2019.
    Add Comment

    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.

    Answered on January 11, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.