If then
 

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.

If then
 

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.

If then
 

Try this...

Sheet2 A2:A10 = list of course names
Sheet2 B2:B10 = quarter

Sheet1 A2 = some course name

Enter this formula in B2 to return the quarter:

=VLOOKUP(A2,Sheet2!A2:B10,2,0)

--
Biff
Microsoft Excel MVP


"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.