Path formula

[efernandes67]

Hi,

See file in attach.

1) In column A I have number between 1 and 53.
2) In column E I have a formula =IFERROR('D:\Test\2012\[File_wk1.xlsx]Inv'!$A$1;"-")

I want to change the formula in cell E2, so the number after "[File_wk", in this case 1, would refer to cell A2. If this is possible I could copy the formulas quickly instead of changing the value in each formula to match the value in column A.

Regards,
Elio Fernandes

[protonLeah]

Post a workbook not pictures.

[efernandes67]

I just found the solution using INDIRECT function.

=IFERROR(INDIRECT("'D:\Test\2012\[File_wk"&A2&".xlsx]Inv'!$A$1");"-")

Elio Fernandes