• Array Position (XL97; SR-2)

    Author
    Topic
    #358191

    Is it possible to return a value from a specific position within an array?

    Example:
    Return a value for position 5 where the array contains 12 positions.

    JS

    Viewing 0 reply threads
    Author
    Replies
    • #533797

      If I understand what you are asking, then I think the INDEX function will do what you want.

      • #533804

        Legare,

        You’re correct.

        INDEX(array,row_num,column_num) returns the value of a specified cell or array of cells within array.

        Thanks,
        JS

      • #533854

        Legare,

        Is it possible to pass an XL file name into an array formula.

        Such as:
        Cell A1 = 1234.xls
        Cell B1=INDEX(E:Hold&A1&’!RangeName,5)

        The result would be INDEX(E:Hold1234.xls’!RangeName,5). This formula works but I can’t seem to pass the cell reference.

        JS

    Viewing 0 reply threads
    Reply To: Array Position (XL97; SR-2)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: