| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup on close file
WHat is the syntax to use vlookup - to gett data from a closed spreadsheet
called my.xls from a tab call sheet1. Thanks you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup on close file
=VLOOKUP(E1,'C:\File location\[my.xls]Sheet1'!$A$1:$B$100,2,0)
"Dan" wrote: WHat is the syntax to use vlookup - to gett data from a closed spreadsheet called my.xls from a tab call sheet1. Thanks you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup on close file
sorry Dan/mama to tag on to your answer with a question...but what if you
have in indirect function to make it go to the right sheet?....i've heard that you can you indirect if the other file is open.... "Teethless mama" wrote: =VLOOKUP(E1,'C:\File location\[my.xls]Sheet1'!$A$1:$B$100,2,0) "Dan" wrote: WHat is the syntax to use vlookup - to gett data from a closed spreadsheet called my.xls from a tab call sheet1. Thanks you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why do i lose EOMONTH on file close | Excel Worksheet Functions | |||
| Everytime i close an excel file, it creates a new backup file | Excel Discussion (Misc queries) | |||
| Copy from another file and close automatically | Excel Discussion (Misc queries) | |||
| Macro to Open, then Close another File | Excel Discussion (Misc queries) | |||
| Disable Macros --> Close File | Setting up and Configuration of Excel | |||
Linear Mode
