Hi I am new to excel formulas and am trying to figure out how to make it so that the data from one table will show in a dropdown selection menu but only the data that is filtered based on predetermined condition. For example: I have an employees table that lists name and department. I want the dropdown to only show the employee names from a specific department that is already predetermined and does not need to be typed in. This dropdown menu populates with names of all employees in the fabrication department for example.

Thank you everyone!