# Pulling values based on selection from drop down box

1. ## 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. ## 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. ## Re: Pulling values based on selection from drop down box

edit.... Got beat by Pete.

4. ## 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!

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. ## 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. ## 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:
`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

8. ## 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!

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

#### 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