I have a workbook that contains two worksheets. One worksheet contains all
compliance regulation training that is required to be taken by department
along with the name of the assigned course(can be selected from drop down
list). On the second worksheet, is the name of the courses and the quarter
when they'll be assigned.

I'd like to add a formula on the first worksheet so that when the course
name is selected, the quarter when the course should be completed will
automatically update in a column in that worksheet.

Please help.