Feb 16 2022 08:12 AM - edited Feb 17 2022 11:29 PM
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