Link to other excel files

[pbjerre]

Hi

As text I need to get the number in the cell from another document:

'C:\Test\data\sensors\[Pressure xbar 11283 Motor 18092020.xlsx]Certificate'!$H$15

I want to combine the file name from cell D8 and C27 plus text. I tried:

=VALUE("'C:\Test\data\sensors\["&C27&D8&".xlsx]Certificate'!$H$15")

In C27 I have the first part of the file name and in D8 I have the date which is a part of the filename.

But this does not have the right format

Any ideas?

[#2]

@pbjerre 

It could be INDIRECT(), but to use it both files are to be opened

[#3]

@Sergei Baklan Thanks. That is working.

[#4]

@pbjerre , you are welcome