find a cell in a file you specify in a different file

[rstolk]

Hello All

I need help creating a formula that will get a specific cell from a specific file in a directory with multiple excel files, where the filename of the file to look in is stated in the cell of the current new excel file.

thanks in advance

best regards

Richard

 

[rstolk]

Dear All,

INDIREXT.EXT did the trick, thanks for all your help and sugestions !

best regards

Richard

 

[gclytle]

The link to Indirect.ext (i.e. http://longre.free.fr/english ) is not working. does anyone know another place to get the addin?