Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
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. -- Lotus123 ------------------------------------------------------------------------ Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611 View this thread: http://www.excelforum.com/showthread...hreadid=486380 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
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. "Lotus123" wrote: 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. -- Lotus123 ------------------------------------------------------------------------ Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611 View this thread: http://www.excelforum.com/showthread...hreadid=486380 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |