If then

A

Aggie G

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

Bernard Liengme

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
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top