vlookup on close file

D

Dan

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

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...
 
Top