Best way of working for linking two sharepoint files dynamically

[NickvdB]

Hi,

Following situation on two sharepoint files:
Source file ("A")

Cost center	Costs
A	50
B	250
C	900

In another file ("B") I would like to be free to just enter A, B or C to get the result from the source file. Without adjusting the formula.

Cost center	Costs
B	250

and another moment

Cost center	Costs
C	900

So I tried with sumifs. However I've read and experienced when the files are used by other persons the sumifs formula will not work because it is "my" formula. What is best way of working to have the red value automatically picking up the correct value in a sharepoint linked excel file without having to adjust and also other people can use the file?

 

[RoryA]

However I've read and experienced when the files are used by other persons the sumifs formula will not work because it is "my" formula.

That is not correct but SUMIFS only works if the source file is open. You don't really need SUMIFS for this anyway, just a lookup of some sort - e.g. VLOOKUP or XLOOKUP depending on which version of Excel you have.

 

[NickvdB]

Thanks for education, and will for sure try the vlookup rightaway! thanks