Compare two spreadsheets, create third with merge

[Guest]

I have one spreadsheet which contains a list of active employees, their
payroll file #, and a unique number which indicates their office location
(1-5). The 2nd spreadsheet contains the payroll file #, and other information
downloaded out of an electronic timesheet program (regular hours, overtime
hours, vacation & sick, etc.). The problem is that the timesheet information
sheet does not include the employee name and location, so that it can be
divided by location and sorted alphabetically. I need to compare the two
sheets and create a third that will merge the data.

I love Excel and I'm usually the one in my office that people come to for
help, but this one has me stumped. Help! I really appreciate it.

 

[Dave Peterson]

This sounds like a job for .... =Vlookup()

Debra Dalgleish has some very nice instructions at:

http://www.contextures.com/xlFunctions02.html