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?????