Thread: Pulling relative information from a seperate workbook

I've been creating a series of workbooks that pull information from one another to make reporting in our organization easier, but I've run into an issue that I can't quite figure out how to solve.

I prefer to use spreadsheet formulas, as my programming isn't that great, but If I have to use Basic, I will. The ultimate goal is as follows:

Workbook 1 has a list of employees (WB 1, Column A) and their employee numbers (WB 1,Column B). Workbook 2 has the same list of employees (WB 2, Column A), but in a different (and what will unavoidably be random) order. Now, the trick I'd like to pull is to have Workbook 2 reference it's own list of employees (WB 2, Column A) and fill the employee numbers into a new column (say, WB 2, Column B) to match the employee name.

To further clarify, Workbook 1 may look like this:

A B
Joe Smith #132
John Johnson #654
Eric Erickson #278
Steve Stevenson #236

And Workbook 2 may contain the same names, but in a different order:

A B
John Johnson #
Steve Stevenson #
Joe Smith #
Eric Erickson #

Now, what's the best way to go about populating column B in the second workbook with the appropriate numbers? Keep in mind, this is a process that needs to be repeated every week, so if it could happen automatically through spreadsheet formulas, that would be the best. Thanks to anyone who can help me out!

That works perfectly. Thank you so much for your help.