Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-04-2012, 12:20 PM
J Press J Press is offline Returning a specific value when item is selected from a drop-down list Windows Vista Returning a specific value when item is selected from a drop-down list Office 2010 32bit
Novice
Returning a specific value when item is selected from a drop-down list
 
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 Returning a specific value when item is selected from a drop-down list Windows XP Returning a specific value when item is selected from a drop-down list 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 Returning a specific value when item is selected from a drop-down list Windows Vista Returning a specific value when item is selected from a drop-down list Office 2010 32bit
Novice
Returning a specific value when item is selected from a drop-down list
 
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, 19 views)
Reply With Quote
  #4  
Old 09-07-2012, 07:49 PM
grizz grizz is offline Returning a specific value when item is selected from a drop-down list Windows XP Returning a specific value when item is selected from a drop-down list 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, 15 views)
Reply With Quote
  #5  
Old 09-10-2012, 06:12 AM
J Press J Press is offline Returning a specific value when item is selected from a drop-down list Windows Vista Returning a specific value when item is selected from a drop-down list Office 2010 32bit
Novice
Returning a specific value when item is selected from a drop-down list
 
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
Returning a specific value when item is selected from a drop-down list 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft