Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-04-2012, 12:20 PM
J Press J Press is offline Windows Vista Office 2010 32bit
Novice
 
Join Date: Sep 2012
Posts: 3
J Press is on a distinguished road
Default Returning a specific value when item is selected from a drop-down list

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.
Reply With Quote
  #2  
Old 09-05-2012, 12:16 AM
grizz grizz is offline Windows XP Office 2003
Novice
 
Join Date: Jan 2012
Posts: 28
grizz is on a distinguished road
Default

a vlookup formula or index match will work but if you could post a sample workbook would help
Reply With Quote
  #3  
Old 09-05-2012, 10:15 AM
J Press J Press is offline Windows Vista Office 2010 32bit
Novice
 
Join Date: Sep 2012
Posts: 3
J Press is on a distinguished road
Default Vlookup

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.
Attached Files
File Type: xlsx Competency and course list 2.xlsx (30.3 KB, 12 views)
Reply With Quote
  #4  
Old 09-07-2012, 07:49 PM
grizz grizz is offline Windows XP Office 2003
Novice
 
Join Date: Jan 2012
Posts: 28
grizz is on a distinguished road
Default

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
Attached Files
File Type: xls Copy of Xl0000362.xls (84.0 KB, 7 views)
Reply With Quote
  #5  
Old 09-10-2012, 06:12 AM
J Press J Press is offline Windows Vista Office 2010 32bit
Novice
 
Join Date: Sep 2012
Posts: 3
J Press is on a distinguished road
Default Thanks Grizz!

I think this is it!
Cheers!
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 09:32 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft