Vlookup, but with changing fileanames...

[Sam_Destoop]

In a excel file, I like to have a copy of a value that is always in cell A1, but everytime in a different excel file. I would like to have a formula that can coop with the (changing) filename, something like vlookup().
Can somebody help? Thx

 

[Gerald Higgins]

Hi, welcome to the board.

How do you (or Excel) know which other workbook to get the value from ?

 

[Sam_Destoop]

the filename is mentioned in the excel where I would like to have the copied values.