| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
