Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

Excel 2007 Macro

i have a Excel list of department numbers and their associated supervisors.  I also have an excel spreadsheet that contains employee names and the department they worked in each day.  I need to be able to open the sheet with the employee names and the department they worked in and have the supervisor name added to each line, for each employee.  How do i do this?????
0
barnescs
Asked:
barnescs
1 Solution
 
Rory ArchibaldCommented:
Use a vlookup formula:

=VLOOKUP(B2,'[other workbook.xlsx]Sheet1'!$A$1:$B$1000,2,false)
for example, assuming department ids in column B in the employee workbook, and the source data in columns A and B in the other workbook.
0
 
barnescsAuthor Commented:
thanks!!!!  This is what i was needing.  have used VLOOKUP between sheets in a workbook but never between workbooks.  Have a great day!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now