Posts by marus_b

    Hello all,


    I'm trying to substitute a static range in a function with a dynamic one, and I cannot seem to get it right.

    Essentially, I have the following function in one of my cells:

    =INDEX(ServiceFees,MATCH($D$2,_Services!$D$2:$D$3,0),MATCH(D4,_Services!$E$1:$J$1,0))

    I would love to be able to substitute the MATCH function ranges for an actual function as follows:

    $D$2:$D$3

    < to be substituted by the following which essentially gives me the same result, except it's not static >

    ADDRESS(CELL("row",ServiceFeesHdrs)+1,CELL("col",ServiceFeesHdrs)) &":"& ADDRESS(CELL("row",ServiceFeesHdrs)+ROWS(ServiceFeesHdrs)-1,CELL("col",ServiceFeesHdrs))

    The address function gives me precisely the same result as the static range address.

    Any help would be greatly appreciated.



    Cordially,

    Marek