The department summary table should look up the department abbreviation and return all of the data listed . It needs to be filled out . To begin , next to the cell listed " department" use a function to search the staff table and return the department name based on the abbreviation above . The formula will be copied , so make sure it always references the abbreviation