Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do VLOOKUPs require the applicable other files to be open?
Do VLOOKUPs require the applicable other files to be open to return a value?
Basically, I have a file that has data pulled (via VLOOKUPs and other such formulae) from 4 other files on various drives. Do I always need to have thes other files open for the VLOOKUPs etc to return a value? Thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do VLOOKUPs require the applicable other files to be open?
They can be closed ... as long as each formula contains the correct path.
This is easily accomplished with both WBs open at the time you are creating the formula, where you make XL create the proper path for you. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "ulupi" wrote in message ... Do VLOOKUPs require the applicable other files to be open to return a value? Basically, I have a file that has data pulled (via VLOOKUPs and other such formulae) from 4 other files on various drives. Do I always need to have thes other files open for the VLOOKUPs etc to return a value? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
files do not open with double click | Excel Discussion (Misc queries) | |||
excel open files very slow | Excel Discussion (Misc queries) | |||
Can't open many XLS files at once | Excel Discussion (Misc queries) | |||
How to open 123 files with excel | Excel Discussion (Misc queries) | |||
How do I open Excel 4.0 files in Office 2000? | Excel Discussion (Misc queries) |