two different excel files on oneDrive

%3CLINGO-SUB%20id%3D%22lingo-sub-2791999%22%20slang%3D%22fr-FR%22%3Etwo%20different%20excel%20files%20on%20oneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2791999%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%2C%20%3CBR%20%2F%3E%20I'm%20looking%20to%20put%20two%20different%20excel%20files%20on%20oneDrive.%3CBR%20%2F%3EIn%20the%20first%20file%20there%20is%20digital%20information%20%3CBR%20%2F%3E%20In%20the%20second%20file%20there%20are%20dates%2C%20and%20I%20am%20trying%20to%20put%20a%20formula%20in%20this%20second%20file%20to%20retrieve%20the%20information%20of%20a%20specific%20cell%20from%20the%20first%20file.%3C%2FP%3E%3CP%3EThis%20works%20very%20well%20on%20my%20local%20computer%2C%20because%20the%20formula%20will%20simply%20search%20my%20drive%20C%3A%20%2F%2F%20......%3CBR%20%2F%3EBut%20in%20Onedrive%20which%20formula%20to%20put%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2791999%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,
I'm looking to put two different excel files on oneDrive.
In the first file there is digital information
In the second file there are dates, and I am trying to put a formula in this second file to retrieve the information of a specific cell from the first file.

This works very well on my local computer, because the formula will simply search my drive C: // ......
But in Onedrive which formula to put?

0 Replies