vlookup with link ot another workbook

  • Thread starter Thread starter CONFUSED AT WORK
  • Start date Start date
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.
 
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.
 
Back
Top