Sharepoint working with excel

I have a spreadsheet that when you enter data in A2 the rest of the sheet auto fills out. I am pulling the data from two separate files that are saved in a different location on the server. The formula I am using is index...match...

I was wondering if I could still use the file but change where I am pulling the data from separate file over to sharepoint. I am being forced into using sharepoint 2016.