Department by employee ID

Vacation requests show only the employee ID.

Pull each employee's department into B2:B8 from the directory in E2:G7.