+ Reply to Thread
Results 1 to 8 of 8

Pulling values based on selection from drop down box

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Pulling values based on selection from drop down box

    I am not sure I posted this in the correct area, my apologies if not.

    I am trying to find the best way to pull data into a series of cells based on the selection made from a drop down box. For example, in the drop down box I have a list of companies we work with. Company A, Company B, and so on. Below the drop down box I need it to populate information for the selected customer, such as Contact name, Phone number, etc.

    I hope this makes sense.


    Thanks for any input you can give.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Pulling values based on selection from drop down box

    You would normally use a VLOOKUP function to do this, or possibly an INDEX/MATCH combination, depending on how your data is laid out. Post an example workbook (the FAQ describes how if you are unsure), and we can then see what your data is like and will be more able to suggest appropriate formulae to you.

    Hope this helps.

    Pete

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Pulling values based on selection from drop down box

    edit.... Got beat by Pete.

  4. #4
    Registered User
    Join Date
    10-23-2012
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Pulling values based on selection from drop down box

    I attached the file (I think) What I am ideally looking to do is select a company from the drop down in C3:D3, and based on that have it reference the other sheet to find the corresponding information and fill in the cells D4:D15.


    Thanks for the quick replies!
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-23-2012
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Pulling values based on selection from drop down box

    Also, as you can see i have made a few of them work with the use of if statements, but I'm sure there is a better way to do this.

    Thanks again!

  6. #6
    Registered User
    Join Date
    10-23-2012
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Pulling values based on selection from drop down box

    Pete,

    I did some research using the VLOOKUP as you recommended, I think it's going to work for me. Thanks for the help everyone. This has been a great first experience with the forum!

    If you see a better way to do what I am looking to do I am all ears, and would love to learn.

    Thanks Again!

  7. #7
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Pulling values based on selection from drop down box

    You need to complete adding the data for each company to the Active Client Table sheet, rather than have individual sheets for each client. Then you will be able to do what is shown in the attached file.

    I have put a MATCH formula in B2 of the Branch Active Customers sheet to determine in which row of the client list in column A the client appears in for the chosen client - this should be the same column number (-1) that the data appears in the Client Table sheet. Then in D4 I have this formula:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    which is then copied down. It retrieves the appropriate data from the Active Client Table sheet, which you can see by changing the selected client in C3.

    Hope this helps.

    Pete
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    10-23-2012
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Pulling values based on selection from drop down box

    Thanks Pete!

    This is exactly what I was looking for!

    I really appreciate the help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1