Dependent Drop Down Box

[JDKrause1169]

What is the excel formula that is dependent on:
the first drop down box is the company name:
then I would like excel generate the exact Address, City, State, Zip, Phone Number, Email adress.

I already have all the information inputted but wanted to get them to link, so when I hit a certain company name it generates the other information.

Thanks!! Been at if for about a week and cannot figure it out.

[Pete_UK]

You could use a VLOOKUP formula, or an INDEX/MATCH combination.

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

[JDKrause1169]

Pete-

They won't let me send any links until I reach a certain amount of posts.
Thanks, so much!

[Glenn Kennedy]

Don't try to attach a link. Follow Pete's instructions and post the file itself.

[JDKrause1169]

Glen,

Thanks for getting back to me. It won't allow me to post a link because I am new to the site.

[Glenn Kennedy]

I know it won't let you post a link... I already said that. I'd advise you to remove your email address quickly, unless you like spam... by the bucket full.

You CAN attach the file directly in this thread (unless it's > 1Mb, in which case save as .xlsb or zip it). So, then reply to the thread and follow these instructions:

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[JDKrause1169]

The following errors occurred with your submission
You are not allowed to post any kinds of links, images or videos until you post a few times.

This is the response I keep receiving!

[JDKrause1169]

Glen

I guess it worked unbeknownst to me!

[Glenn Kennedy]

Is this what you meant?? In K2, copied across and down:

=IFERROR(VLOOKUP($J2,$B:$H,COLUMNS($A:B),FALSE)&"","")

I edited your posts and removed your email address....

[JDKrause1169]

Glenn

Thanks so much. I will let you know if it works.

Jon

[JDKrause1169]

You are awesome!!!!!!!!!

Thanks

[Glenn Kennedy]

Not awesome... just done it many times!!

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

[JDKrause1169]

Glen -

sorry to bother you!

Can you show me how to copy the formula to work in the main spreadsheet? Ie: I would like to carry the formula to existing conditions, etc.

[Glenn Kennedy]

Sure. Can you post it?

[JDKrause1169]

No It keeps returning a value of 0

[Glenn Kennedy]

If I can't see what you've done, it's not easy to help!!