vlookup with link ot another workbook

C

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

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