| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup multiple workbooks
I am attempting to use VLOOKUP to link 2 workbooks together.
This formula works fine: =VLOOKUP(A4,[test1.xls]Sheet1!$A$4:$A$1000,1,FALSE), However, when I try to copy this formula into another workbook where the workbook name has a space in it, i.e., test 1, I get this error message: Name invalid. Any Suggestions?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| work with multiple workbooks on separate monitor for 2003 edition | Excel Worksheet Functions | |||
| VLookup across Workbooks? | Excel Worksheet Functions | |||
| Vlookup on multiple workbooks | Excel Discussion (Misc queries) | |||
| Vlookup in Multiple Workbooks | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Threaded Mode
