I have a spreadsheet (call it Employees) with of demographic data on employees, ~30 columns and 5000+ rows.

One column contains the numeric code for the department in which they reside. There are hundreds of these department codes, and they are not unique (each row is unique however, as it represent a single employee).

I have another spreadsheet (call it Safety Training) with a column that list all department codes that need to take a safety course.

What I'd like to do is create a subset of only those rows in the Employees spreadsheet which contain the department codes in the Safety Training Spreadsheet.

Any help is appreciated.