Hi,
I'm having a bit of difficulty in populating a desired list through the use of a combo box, I'm hoping someone here has he smarts to help me.
We have a training register to show the mandatory training required per position, I would like the user to select the position from the combo box & underneath the mandatory training for that position will appear.
Data is in a table, copied below (I can't upload here for some reason?). So in the combo box I have linked it to a vertical list of the positions, CEO, OPs Mgr etc, I can see them in the combo list. Ideally then if someone could help with a formula to index the position, find all the X's in that column & change the X's to the training in the course name column. I really hope this makes sense but if not please ask away!

So from example below if a user selects Chief Executive Officer in the combo box then underneath the combo box we should see Staff Safety Induction, General Construction Induction & nothing else.

Course Name Course Code Chief Executive Officer Operations Manager Office Manager
Staff Safety Induction X X X
General Construction Induction PCCOHS1001A X X
Provide first aid (HLTAID003) O
Provide cardiopulmonary resuscitation CPR) (HLTAID001) O