vlookup with link ot another workbook

[CONFUSED AT WORK]

Can I update the information through anohter workbook?

=IF(LEN(G11)=0,"",VLOOKUP(G11,Customers!$A$3:$C$1075,3,FALSE))

instead of customers I want a sheet from another file, so I would have to do
the path name, and name of the sheet, and lookup area? If there is a easier
way please let me know.

Currently I type in 350, and then it updates the name automatically.

Thanks.

 

[Douglas J. Steele]

Sorry, this newsgroup is for questions about Access, the database product
that's part of Office Professional.

You'd be best off reposting your question to a newsgroup related to Excel.

 

[David H]

You've posted in a newsgroup dealing with MS Access. For something this
specific concerning MS Excel, you'll need to post in an appropriate Excel
newsgroup.

http://www.microsoft.com/office/com...ublic.excel.worksheet.functions&lang=en&cr=US