integrate value of cell A3 into formula

[Pitoun]

Hello,

I try to find a way to integrate A3 cell value into formula


I got a folder full of invoices. File names are consecutive numbers starting with 180000.xlsx
I want to extract for each file five differents cells.

I'd like to manually write in colon A all file names without extension (180000, 180001, 180002, ...)
Then I'd like to autofill up my formula with composed value of cell A into cells B to F

B3 ='C:\Factures\[INDIRECT("A3")&".xls"]Facture 1'!$F$10
C3 ='C:\Factures\[INDIRECT("A3")&".xls"]Facture 1'!$B$15
D3 ='C:\Factures\[INDIRECT("A3")&".xls"]Facture 1'!$G$31
E3 ='C:\Factures\[INDIRECT("A3")&".xls"]Facture 1'!$B$32
F3 ='C:\Factures\[INDIRECT("A3")&".xls"]Facture 1'!$B$33

I also tryed with =CELLULE("contenu";A3)&".xlsx" without success.

Any help or instruction are welcome

Best regards,

Pierre-Ed.

 

[Joe4]

If your other workbook is open, you the formula would look like this:

=INDIRECT("[" & A3 & ".xls][COLOR=#333333]Facture 1'!$F$10[/COLOR]")

If your workbook is closed, you cannot use the INDIRECT function on it. As matter as fact, it looks like VBA may be the only way to do it.
Have a look here: https://forums.windowssecrets.com/s...ex-Indirect-Match-Function-on-Closed-Workbook