Working on a log and would like Excel to find the department number and enter
it into the cell next to name when name is entered into the log. Have
created a list with names in column "A" and department #'s in column "B" .
Sheet 1 named Log
Sheet 2 named Names List