D Dan Jun 3, 2008 #1 WHat is the syntax to use vlookup - to gett data from a closed spreadsheet called my.xls from a tab call sheet1. Thanks you
WHat is the syntax to use vlookup - to gett data from a closed spreadsheet called my.xls from a tab call sheet1. Thanks you
T Tami Jun 3, 2008 #3 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 said: =VLOOKUP(E1,'C:\File location\[my.xls]Sheet1'!$A$1:$B$100,2,0) Dan said: WHat is the syntax to use vlookup - to gett data from a closed spreadsheet called my.xls from a tab call sheet1. Thanks you Click to expand... Click to expand...
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 said: =VLOOKUP(E1,'C:\File location\[my.xls]Sheet1'!$A$1:$B$100,2,0) Dan said: WHat is the syntax to use vlookup - to gett data from a closed spreadsheet called my.xls from a tab call sheet1. Thanks you Click to expand... Click to expand...
