Returning a specific value when item is selected from a drop-down list

J Press · #1 09-04-2012, 12:20 PM

I have created drop-down lists (course titles) from data tables listed on other worksheets. When a particular course is selected from a drop-down list, I want Excel to automatically populate the related value (course hours) from the same data tables.

grizz · #2 09-05-2012, 12:16 AM

a vlookup formula or index match will work but if you could post a sample workbook would help

J Press · #3 09-05-2012, 10:15 AM

Thanks for the offer to help Grizz. I've attached posted a sample. On the 'Level Requirements' worksheet is where I have the drop-down lists. When a particular course is selected from the drop-down list, I would like to have the number of 'Hrs' listed from the 'Level 1-PL1 Course Lists worksheet automatically populate next to course selected.

grizz · #4 09-07-2012, 07:49 PM

I am sorry it took so long to get back to you but I have been away
take a look at this workbook and let me know if it helps

J Press · #5 09-10-2012, 06:12 AM

I think this is it!
Cheers!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show the first item of a drop-down list instead of a blank	Pragabhava	Excel	1	12-29-2011 11:48 PM
Automatically select first item in drop-down?	flackend	Excel	4	08-29-2011 02:07 PM
Insert an item to excel specific cell	apjneeraj	Excel	0	01-18-2011 03:39 AM
25 item max in drop down form	sonicvalley	Word	0	07-26-2010 11:12 PM
Referens to an item list...	matbli	Word	0	10-29-2009 08:04 AM