Excel Formula Help

Hi, I need to add department ID numbers only to a separate work sheet tab using the department name as the criteria. I added the department list and department ID information on a separate tab. What ...