Why does the VLOOKUP function does not work with file links?

The following function outputs nothing:


If I open ‘otherfile.ods’ and paste this same formula, it works flawlessly, producing the output I want.

Is there a reason for this to happen or is it just a bug?

I cannot reproduce.