Concatenate text in cells to a formula.

  • Hi there


    I have aproblem that I do hope someone can help me with:
    In Cell A1 I have a part of a path as text: C\mads\private\
    In Cell A2 I have the rest of the path still as text: [min 2015.xlsm]Feb'!$C$9. This part of the path is getting information from cell C9 on Sheet Feb.
    In A3 I want to write the two parts of the path as a formula so I can get the informaion from document min 2015.xlsm ceel C9 on sheet Feb. Is that possible??


    Thank you in advance.


    Regards
    Mads Alring

  • Re: Concatenate text in cells to a formula.


    There is a problem to finding a solution to what you want to do.


    The answer should be
    =SUM(INDIRECT(A1&A2))


    but you cannot use INDIRECT in connection with a closed workbook. it will return an answer of #REF!

    [COLOR="Purple"]Regards,[/COLOR]
    [COLOR="Purple"]Batman.[/COLOR]

  • Re: Concatenate text in cells to a formula.


    Hi Batman


    You saved my day. Thank you for the help.


    As long as I in A1 write [min 2015.xlsm] and in A2 write Feb'!$C$9 then all is perfect. And as you said the other document have to be open.


    Regards
    Mads