ExcelBanter - vlookup on close file

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - vlookup on close file (https://www.excelbanter.com/excel-worksheet-functions/189812-vlookup-close-file.html)

dan

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

Teethless mama

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

Tami

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

All times are GMT +1. The time now is 04:54 PM.