vlookup worksheetfunction
 

What is the proper syntax for using

application.worksheetfunction.vlookup(emb,"c:\list s\filename.xls"!sheet1.A1:AB300,5,false)

Basically how do you use the worksheetfunction vlookup looking up in a
different file, with the full path in case the file is not open

vlookup worksheetfunction
 

application.worksheetfunction.vlookup(emb,workbook s("c:\lists\filename.xls")
..worksheets("sheet1").range("A1:AB300"),5,false)

don'tknow what emb is.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"ben" wrote in message
...
What is the proper syntax for using


application.worksheetfunction.vlookup(emb,"c:\list s\filename.xls"!sheet1.A1:
AB300,5,false)

Basically how do you use the worksheetfunction vlookup looking up in a
different file, with the full path in case the file is not open

vlookup worksheetfunction
 

The file must be open:

application.worksheetfunction.vlookup(emb,Range("[filename.xls]sheet1!A1:AB3
00"),5,false)

--
Regards,
Tom Ogilvy


"ben" wrote in message
...
What is the proper syntax for using


application.worksheetfunction.vlookup(emb,"c:\list s\filename.xls"!sheet1.A1:
AB300,5,false)

Basically how do you use the worksheetfunction vlookup looking up in a
different file, with the full path in case the file is not open

vlookup worksheetfunction
 

workbooks("c:\lists\filename.xls")

Come on Bob - No way!

--
Regards,
Tom Ogilvy

"Bob Phillips" wrote in message
...

application.worksheetfunction.vlookup(emb,workbook s("c:\lists\filename.xls")
.worksheets("sheet1").range("A1:AB300"),5,false)

don'tknow what emb is.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"ben" wrote in message
...
What is the proper syntax for using



application.worksheetfunction.vlookup(emb,"c:\list s\filename.xls"!sheet1.A1:
AB300,5,false)

Basically how do you use the worksheetfunction vlookup looking up in a
different file, with the full path in case the file is not open

vlookup worksheetfunction
 

Whoops, forgot my smiley face <g

Come on Bob - No way! ;-)

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
workbooks("c:\lists\filename.xls")

Come on Bob - No way!

--
Regards,
Tom Ogilvy

"Bob Phillips" wrote in message
...


application.worksheetfunction.vlookup(emb,workbook s("c:\lists\filename.xls")
.worksheets("sheet1").range("A1:AB300"),5,false)

don'tknow what emb is.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"ben" wrote in message
...
What is the proper syntax for using




application.worksheetfunction.vlookup(emb,"c:\list s\filename.xls"!sheet1.A1:
AB300,5,false)

Basically how do you use the worksheetfunction vlookup looking up in a
different file, with the full path in case the file is not open