Populate list based on criteria

I have a list of (30) classes that people need to take based on different criteria, like title, department, etc. I want to select a title from a drop down, and enter a job code into a field, and select a department from another drop down and then Excel populates a list of classes the person should take.

For Example:

Stock person gets Course A, C
Cashier gets Course A, C, F
Department 1 gets A
Department 2 gets A, B
Job Code 5555 gets Course B, C, E

Cashier is in department 2 and has Job Code 5555, so should get A, B, C, E

Can someone please help me with this? I am running Office 2013.

You may be referring to Dependent Drpdown lists.

Check out great examples here.

http://www.contextures.com/xlDataVal13.html

Hello Hazellboo and Welcome to Excel Forum.
This is a low tech proposal for a solution.
The data is on sheet1 and the results are listed on sheet2.
On sheet2 cells A2 and C2 have data validation drop downs applied, as it was stated that the code would be entered (typed).
Cells J2:O2 list the classes based on Title using the formula:

Formula:

Please Login or Register  to view this content.

Cells P2:U2 list the classes based on Code (using a similar formula).
Cells V2:AA2 list the classes based on Department.
Cells J2:AA2 may be moved and/or hidden for aesthetic purposes.
The composite of the classes is then listed in D2:I2 using the formula:

Formula:

Please Login or Register  to view this content.

If isn't the output you want or the data isn't compatible with your set up, please upload a sample spreadsheet with the expected results mocked up manually (we'll try and figure out formulas/code to match those results).
To upload a spreadsheet click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.