Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

excel 2013 drop down lists


  • Please log in to reply
3 replies to this topic

#1 jpd9930

jpd9930

  • Members
  • 221 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:11:10 PM

Posted 18 February 2015 - 01:18 PM

I hope I have the right forum. I created a drop down list in excel 2013 but I want to link specific data to each selection in the dropdown box to be displayed in other boxes on the spreadsheet. I have the dropdown list on a separate sheet from where I store the data to be displayed.

 

Ex.

select 1 and populate a,b,c,d

select 2 and populate e,f,g,h

select 3 and populate I,j,k,l

etc

 

something like

sales area/     employees

south/             Bob, Jane, Russ

North /            Jeff. Carl, Pat

West/             Richard, Matt, Josh

 

When I pick South I want the corresponding employees to be displayed..

 

I want to link 5 items to the drop down list selection. The data is arranged in a row (left to right) but I have the display boxes arranged in columns (top to bottom). I can change that if need be. only one dropdown box will be used.

 

I have used excel before but still a novice at most of the more intermediate functions.

 

I hope that makes sense 


Edited by jpd9930, 18 February 2015 - 01:19 PM.


BC AdBot (Login to Remove)

 


#2 Budapest

Budapest

    Bleepin' Cynic


  • Moderator
  • 23,577 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:01:10 PM

Posted 19 February 2015 - 05:01 AM

I think you should be able to achieve this with the "vlookup" function.

 

VLOOKUP function


The power of accurate observation is commonly called cynicism by those who haven't got it.

—George Bernard Shaw

#3 jpd9930

jpd9930
  • Topic Starter

  • Members
  • 221 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:11:10 PM

Posted 19 February 2015 - 11:52 AM

AWESOME!!!!!! that is exactly what I was looking for! works like a charm! I have so many uses for this its mind boggling, at least to me...LOL

 

As always BP staff solve MY problems....

 

have a great day and many thanks....



#4 Budapest

Budapest

    Bleepin' Cynic


  • Moderator
  • 23,577 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:01:10 PM

Posted 19 February 2015 - 04:14 PM

:thumbup2:


The power of accurate observation is commonly called cynicism by those who haven't got it.

—George Bernard Shaw




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users