 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2007Working with Drop Down List
I've looked around in the FAQ and other help areas - maybe I'm asking the question wrong. (Not uncommon) I have seen this done in the past - but I can't remember how it was created... I have a list of room numbers - in a separate column I have a list of room names. I recall that there was a way to create the list so that if someone chose the room number from the list - the associated room name would appear adjacent to it... Was I dreaming? Is this possible? Or is this an INDEX (array) sort of thing? Any help would be greatly appreciated. VLOOKUP? If Room Numbers and Names are (for example) in Columns A & B of Sheet2 (rows 1 to 20) and your drop down is in A2 of Sheet1: Then in Sheet1 B2: =VLOOKUP(A2,Sheet2!$A$1:$B$20,2,0) will give room name in B2 > I've looked around in the FAQ and other help areas - maybe I'm asking the > question wrong. (Not uncommon) [quoted text clipped - 9 lines] > > Any help would be greatly appreciated. Thanks - that works! Who knows is that's how we did it in the past - but that works just great! J > VLOOKUP? > [quoted text clipped - 18 lines] > > > > Any help would be greatly appreciated. Thank you for the feedback. > Thanks - that works! > [quoted text clipped - 24 lines] > > > > > > Any help would be greatly appreciated. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.