vlookup

H

HGJ

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.
 
E

Elkar

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.
 
L

Lotus123

If I interpret your question correctly, it sounds like Excel has stored
the most recent values from the third-person file in the current file
you are using. This is one of the reasons using vlookup will bloat the
size of your Excel file. Not sure if that was the answer you were
looking for.
 
H

HGJ

I am not in same network, I did not know that Excelstors the most recent
values from the third-person file.
can excel can have an Embedded file for look up.
 
Top