VLOOKUP in another file

VLOOKUP in another file

Dear Zoho Sheet Team,

I've been trying to find the way to use VLOOKUP() in another file (as OpenOffice and MS Office can) and haven't find yet.

Is it possible? I tried this, for example:

=VLOOKUP(A1;'one'$Sheet1.$A$1:$F$500;2;0)

Thank you.