Range showing (table array) in the wrong place

I’ve got a VLOOKUP pulling data from another excel file (sources.xlsx) the formula works as intended it's pulling the right department names based on id number, but here’s the weird part, when I double click the formula to check it, the table array ($A$2:$B$23) gets highlighted in the current sheet instead of the actual source sheet (which is in the other file).

The data is still coming in correctly, just excel is showing the range in the wrong place. Is this normal when referencing another workbook? I never experience this before, and I am not sure if it new thing or a bug

Example