Link to other excel files

%3CLINGO-SUB%20id%3D%22lingo-sub-1763755%22%20slang%3D%22en-US%22%3ELink%20to%20other%20excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1763755%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EAs%20text%20I%20need%20to%20get%20the%20number%20in%20the%20cell%20from%20another%20document%3A%3C%2FP%3E%3CP%3E'C%3A%5CTest%5Cdata%5Csensors%5C%5BPressure%20xbar%2011283%20Motor%2018092020.xlsx%5DCertificate'!%24H%2415%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20combine%20the%20file%20name%20from%20cell%20D8%20and%20C27%20plus%20text.%20I%20tried%3A%3C%2FP%3E%3CP%3E%3DVALUE(%22'C%3A%5CTest%5Cdata%5Csensors%5C%5B%22%26amp%3BC27%26amp%3BD8%26amp%3B%22.xlsx%5DCertificate'!%24H%2415%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20C27%20I%20have%20the%20first%20part%20of%20the%20file%20name%20and%20in%20D8%20I%20have%20the%20date%20which%20is%20a%20part%20of%20the%20filename.%3C%2FP%3E%3CP%3EBut%20this%20does%20not%20have%20the%20right%20format%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1763755%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1764822%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20to%20other%20excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1764822%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F759605%22%20target%3D%22_blank%22%3E%40pbjerre%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20could%20be%20INDIRECT()%2C%20but%20to%20use%20it%20both%20files%20are%20to%20be%20opened%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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?

 

3 Replies
Highlighted

@pbjerre 

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

Highlighted

@Sergei Baklan Thanks. That is working.

Highlighted

@pbjerre , you are welcome