Auto Fill Cells after selecting from a drop down list

[laws85]

Hi I am new to this forum and really hoping someone can help me.

I am creating a training matrix in excel identifying training requirements by job title/position. There is a front index page with a column for each position, a row each type of training and then a Y/N in the position column for whether it is required for that position, then worksheets a -z for individuals records (based on surnames)

I have created a drop down list so each job title can be selected and would now like this to automatically fill the cells below with the Y/N data in the front index page position column e.g. If I select receptionist in the drop down list is auto fills the cells below with the appropriate info from the index page.

I am a real novice in excel, am not even sure how to explain what I want clearly and have got the sheet as far as I can without some help now! - Please be gentle I am really new to this.

[samba_ravi]

pls attach sample excel fileattach file.png

[laws85]

Example.xlsx

Hopefully example attached, thank you

I want to be able to select from drop down list (job titles from the essentials index page) - work sheet 'A' Column CDE11 and the information auto fill into column d12:65 from the 'essentials index' associated with the selection made

[laws85]

Really hoping someone on here can help