Greetings,

I have two dropdown boxes. The first one has a list of jobs. Once you select a job the second dropdown box will populate a list of fields for that job even though all the fields are the same for each job. When I select a field from second dropdown box I want to be able to populate a cell with a candidate for that field. For instance. If I select Job1 then select Field1 I want it to return Person1 in a given cell. Job1 then field2 then Person2. Job1 then field3 then Person3 and so on. I have attached a sample workbook as a simplfied example. It contain two sheets.

Thank you

SampleWorkbook.xlsx