Are you both on the same network? My guess would be that the VLOOKUP is
referring to a file that you both have access to.

"HGJ" wrote:

I received an excel sheet from my co-worker which has VLOOKUP function, the
lookup range in a different file.
I received only the file with the function VLOOKUP but not the link file but
the function works. When I change the value it shows the right look up value
how is it possible.