Hello

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


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