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.