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