How to use "indirect" search for information on other working folder.

[iuriaraujo]

HOW TO USE "INDIRECT" SEARCH FOR INFORMATION ON OTHER WORKING FOLDER.

PLANILHA_CONTROLE.XLS COLLECTION IN USING THE MANUAL WE VALUE: = 'D: \ Documents - Projects \ PROJECTS \ IURI \ Phase 2 \ Phase 2-1 \ [11448.xls] Folhas_92'! $ G $ 13


CELLS HAVE DIFFERENT SITES WITH A sequence of values ​​that also corresponds to the file names, WHO WANT TO FIND THE INFORMATION [??????. XLS] Folhas_92! G13
114448
114443

PRECISE AMOUNT OF CEL "G13" FOR EACH OF THE 350 HAVE FILES, USING INDIRECT, HOW CAN I FIND THIS INFORMATION?

INDIRECT ("'[' = D: \ Documents - Projects \ PROJECTS \ IURI \ Phase 2 \ Phase 2-1 \ "& A1 &". Xls] Folhas_92!''G13 ") THE RESULT WAS # REF!

"& A1 &" Complements 11448.xls FILE NAME, BUT EVERY TIME ONLY BRINGS # REF! , WOULD LIKE TO KNOW IF THE FILES WITH CLOSED, THESE VALUES MAY GO reference to cells LOCAL NAMES OF THE FILES.

[NBVC]

INDIRECT function does not work with other workbooks if they are closed. You will need the other workbook to be opened or you will need to install an addin from a free website and use a similar function called INDIRECT.EXT to replace INDIRECT.

This is the formula if the workbook is open:

=INDIRECT("'[D:\Documents - Projects\PROJECTS\IURI\Phase 2\Phase 2-1\"& A1 &". Xls]Folhas_92'!G13")

you can get the free addin from here: Morefunc

[iuriaraujo]

Tradução do português para inglês

How can I access data in Excel from another worksheet based on local reference.

I need only the value of each arquivo.xls G13
I have three files with the following names.
1112.xls
1113.xls
1114.xls

I have the 4th folder that is trabalhho dados.xls

Column A have the information you want to use as a reference within the formula to indicate the name of the file that contains the value I need.
1112
1113
1114

Example: = 'D: \ Documents - Projects \ Projects \ Phase 2 \ Phase 2-1 \ ["& A1 &". Xls.xls] Folhas_02'! $ G $ 13


There are dozens of files, how can I get information on all of them.

[NBVC]

I think I showed you how above.

[iuriaraujo]

With the file open or closed is giving error.


=INDIRECT.EXT ("'[D:\Documents - Projects\PROJECTS\ETELGE\Phase 2\Phase 2-1\"&A1&".Xls] Folhas_Vistoria!'G13')

Please, help me

[NBVC]

S/b, I think:

=INDIRECT.EXT ("'D:\Documents - Projects\PROJECTS\ETELGE\Phase 2\Phase 2-1\["&A1&".Xls]Folhas_Vistoria'!G13")