Please help with multiple dependant drop down lists

**kartoshka** · 05-11-2013, 06:36 PM

Good evening everybody,

first of all i would like to say that im new to the forum and for now it seems great, lots of helpful people.

I'm writing because i have and issue with drop down lists and have not found the solution for me, im not an expert in excel i know the basics.

I have a list of customers, this customers belong to branches like beverage, food, etc, the branch is the master for the next drop downs that contain 1) competitors for this branches and 2nd) group that this customers belong, this 2 variables are dependent to the branch.

I cant figure out how to make the drop down list dependent on the branch.

Attached my file with the example

Can anyone help me?

Thank you

**XOR LX** · 05-11-2013, 06:53 PM

Evening.

Have a look at the attached and let me know if that's what you were after.

Regards

**FDibbins** · 05-11-2013, 07:15 PM

The way you need to do this, is to create a range name for each category - something that matches what the options are in the 1st drop-down...then reference that name for the 2nd dropdown, using...
=INDIRECT(A2)

for the 3rd drop-down (OEM), use the same approach, but add a 1 (or O - doesnt really matter what) to the end of the named ranges.

then for the OEM D/D, use...
=INDIRECT(A2&1)

**XOR LX** · 05-11-2013, 07:19 PM

FDibbins,

Did you not look at my attachment?

Precisely what I did for them, including all the Named Ranges!

**FDibbins** · 05-11-2013, 07:44 PM

XOR....I had this thread open for a while, and saw what you had after I posted....good job

**kartoshka** · 05-12-2013, 07:57 AM

Hello all,

Thanks a lot for the answers!

This is exactly what i was looking for, thanks a lot XOR LX !

very happy to have joined the forum.

Best regards and good weekend

**XOR LX** · 05-12-2013, 07:59 AM

Glad to have helped. Good weekend to you, too!

Please help with multiple dependant drop down lists

LinkBack

Thread Tools

Rate This Thread

Display

Please help with multiple dependant drop down lists

Re: Please help with multiple dependant drop down lists

Re: Please help with multiple dependant drop down lists

Re: Please help with multiple dependant drop down lists

Re: Please help with multiple dependant drop down lists

Re: Please help with multiple dependant drop down lists

Re: Please help with multiple dependant drop down lists

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions