VLOOKUP between 2 files in sharepoint

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3174033%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bfr-FR%5C%26quot%3B%22%3EVLOOKUP%20between%202%20files%20in%20sharepoint%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3174033%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bfr-FR%5C%26quot%3B%22%3E%3CP%3EHello%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20trying%20to%20apply%20a%20VLOOK%20formula%20between%20to%20spreadsheets%20that%20are%20on%202%20different%20sharepoint%20sites%20on%20the%20same%20tenant.%20Not%20only%20is%20there%20a%20question%20of%20accessing%20the%20data%20but%20also%20how%20to%20manage%20the%20permissions%20between%20the%202%20sites.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3CPRE%20class%3D%22%5C%26quot%3Blia-code-sample%22%20language-applescript%3D%22%22%3E%3CCODE%3E%3DIF(%24K3%3D0%2C%5C%22%5C%22%2CIF(%24K3%3DVLOOKUP%2C%5C'https%3A%2F%2F***.sharepoint.com%2F%3Ax%3A%2Fr%2Fsites%2FVMLYRITPAR57%2FShared%2520Documents%2FGeneral%2F****%2520INVENTAIRE%2F%5BVMLYR%2520GROUP%2520%2520PARIS%2520USER%2520MACHINE%2520INVENTORY.xlsx%5DVMLYR_RF%5C'!(%24K3%2CVMLYR_RF_TABLE%2C5)))%26lt%3B%5C%2Fcode%26gt%3B%26lt%3B%5C%2Fpre%26gt%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EIn%20idea%20is%20that%20the%20formula%20looks%20up%20the%20table%20range%20VMLYR_RF_TABLE%20in%20the%20tab%20VMLYR_RF%20of%20the%20xlsx%20file.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20on%20if%20it%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3174033%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bfr-FR%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EExcel%20for%20web%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EOffice%20365%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3174033%22%20slang%3D%22fr-FR%22%3EVLOOKUP%20between%202%20files%20in%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3174033%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20trying%20to%20apply%20a%20VLOOK%20formula%20between%20to%20spreadsheets%20that%20are%20on%202%20different%20sharepoint%20sites%20on%20the%20same%20tenant.%20Not%20only%20is%20there%20a%20question%20of%20accessing%20the%20data%20but%20also%20how%20to%20manage%20the%20permissions%20between%20the%202%20sites.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(%24K3%3D0%2C%22%22%2CIF(%24K3%3DVLOOKUP%2C'https%3A%2F%2F***.sharepoint.com%2F%3Ax%3A%2Fr%2Fsites%2FVMLYRITPAR57%2FShared%2520Documents%2FGeneral%2F****%2520INVENTAIRE%2F%5BVMLYR%2520GROUP%2520%2520PARIS%2520USER%2520MACHINE%2520INVENTORY.xlsx%5DVMLYR_RF'!(%24K3%2CVMLYR_RF_TABLE%2C5)))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20idea%20is%20that%20the%20formula%20looks%20up%20the%20table%20range%20VMLYR_RF_TABLE%20in%20the%20tab%20VMLYR_RF%20of%20the%20xlsx%20file.%3C%2FP%3E%3CP%3EAny%20thoughts%20on%20if%20it%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3174033%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

Hello

I trying to apply a VLOOKUP formula between to spreadsheets that are on 2 different sharepoint sites on the same tenant.

 

=IF($K3=0,"",IF($K3=VLOOKUP,'https://***.sharepoint.com/:x:/r/sites/*****ITPAR57/Shared%20Documents/General/****%20INVENTAIRE/[****%20GROUP%20%20PARIS%20USER%20MACHINE%20INVENTORY.xlsx]****_RF'!($K3,****_RF_TABLE,5)))

 

In idea is that the formula looks up the table range VMLYR_RF_TABLE in the tab VMLYR_RF of the xlsx file.

Sadly, it is not working and excel does not indicate why.

Any thoughts on this are most welcome

0 Replies