Link to Excel 365 spreadsheet

Occasional Visitor

I'm using Office 365. I have a spreadsheet on sharepoint that is updated nightly named spreadsheet1.xlsx. The link to the spreadsheet looks similar to this .  I want to use Xlookup to query spreadsheet1.xlsx and pull the data back into spreadsheet2.xlsx which is also on Sharepoint.  


Any help would be greatly appreciated.

0 Replies