Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Refrencing an entire worksheet?
Is it possible to refrence an entire worksheet from another workbook (which is unopened) so that I can use its cells for a Vlookup? Thanks Graham -- el_grimley ------------------------------------------------------------------------ el_grimley's Profile: http://www.excelforum.com/member.php...o&userid=25924 View this thread: http://www.excelforum.com/showthread...hreadid=401954 |
#2
|
|||
|
|||
One way:
=VLOOKUP(A1,[Workbook2]Sheet1!$A:$IV,123,FALSE) It's easiest to create the link with the workbook open, as shown above. Otherwise, include the path in your reference. In article , el_grimley wrote: Is it possible to refrence an entire worksheet from another workbook (which is unopened) so that I can use its cells for a Vlookup? Thanks Graham |
#3
|
|||
|
|||
It's easier if you open the other workbook first and use the mouse to select
=VLOOKUP(D1,[myfile.xls]Sheet1!$1:$65536,3,0) then excel will add the necessary path when you close the workbook =VLOOKUP(D1,'C:\Documents and Settings\My Name\My Documents\[myfile.xls]Sheet1'!$1:$65536,3,0) otherwise you have to build the path yourself -- Regards, Peo Sjoblom (No private emails please) "el_grimley" wrote in message ... Is it possible to refrence an entire worksheet from another workbook (which is unopened) so that I can use its cells for a Vlookup? Thanks Graham -- el_grimley ------------------------------------------------------------------------ el_grimley's Profile: http://www.excelforum.com/member.php...o&userid=25924 View this thread: http://www.excelforum.com/showthread...hreadid=401954 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I copy an entire worksheet to another with text & format? | Excel Discussion (Misc queries) | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Linking cells in a worksheet to other worksheets in a workbook | Excel Discussion (Misc queries) | |||
Worksheet Function - Find? | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |