Search output in list form using Excel spreadsheet

Hello Everyone,

I want to create a spreadsheet which looks like a dashboard giving an option to choose from 3 dropdown lists like Function, Sub-function and Role. Upon selecting these 3 options, I need a list of training required to be completed for the selected role under particular function and sub-function combination. This list will be dynamic based on the parameters selected.

I have attached a sample file - first sheet is where the output should appear; second sheet will have the databank.

I need your help in determining whether I need to use VBA programming or Pivot or vlookup or other formulas. It will help further if you direct me to VBA code or formulas that can help solve this problem.

Thank you in advance!

Best,
NG