Have look in Help at VLOOKUP
Then come back with questions but please give us some idea of the layout of
the second worksheet
best wishes

--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Aggie G" wrote in message
...
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.