The Department summary table should look up the department abbreviation and return all of the data listed

Business Apr 22, 2023

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 data (not including the row of headings and the total row) and return the department name based on the abbreviation above. The formula will be copied, so make sure it always references the abbreviation.

Number 13 from an assignment: NP_EX365_2021_CT_CS1-4c_