I have a matrix of required training for job titles. The titles of the jobs are down column 2 of Sheet1. The required training titles are across row 1 as a header row. Required training is indicated by an "X" in the corresponding cell of "Job Title" and "Training Title."

I have made a second sheet that I created a drop down list of job titles, referencing the titles in sheet 1. In the cells underneath that job title, I want to automatically display the required training titles once I choose a job.

Most of the info I have found refers to looking up a cell value based on row and column. But not column name based on row name and cell value. If anyone has any info on how I should write this, please let me know. I'd appreciate anything I can get.