Lookup and Match Data from another spreadsheet

Hi and please bear with me on this one, Excel is not my functions are not my strongest point.

A task I have been presented with is to total up the working hours logged per individual AND per department.

The reports I am able to extract I can easily filter to the individual however I need a way to filter by departments. 

So, I have a spreadsheet (the master) with 3 columns, Staff Name, Employee ID, Department.

On the extracted report I get the staff name, employee ID and Hours logged.

I would like to, from the report spreadsheet, look up and match the employee ID from the master spreadsheet, and pull across their department into a new column in the report spreadsheet, this would allow me to filter by department.

I hope this makes sense and thanks in advance for any support offered.