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

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 10:39 PM.


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