Multiple Drop down lists and their combnation

[mahendra2210]

I am trying to create multiple distribution lists in A1 to D1, all these
distribution lists have different text in them.
Now, my problem is that "Is there any way in excel using which I can get the
result of any combination in cell E1"......

For Example:
If I have 5 different items in each distribution list from A1-D1, it means
that I can have 5X5X5X5=625 possible outcomes. But I know that only certain
number of outcomes are useful for me...let's say... 50 among these all are
useful and I know what are their respective combintions in cell A1-D1.

So, my question is ""Is there any way using whch I can input details for all
these 50 useful outcomes and get their result in cell E1 with the help of my
selection in cell A1-D1""????

 

[James]

If I understand your question right, you want the totals from 5 different
drop down boxes to be displayed in E1.
in E1 type the following
=sum(A11)
now if the dropdown boxes are all 0, E1 should display 0, as soon as you
change one of the dropdown boxes to any other number, E1 should change
accordingly.

Hope that helps and answers your question.

 

[mahendra2210]

Hey James,

Thanks for your response. But, unfortunately that's not I was looking for.

I'll rephrase my question:

"I have a distribution list of 5 cities in cell A1, 5 manufacturers in cell
B1, 5 products category in cell C1, and 5 product list in cell D1."

Now, I want that if I select one particular city in cell A1, then it should
give me options to select manufacturers available in that city only.

Again, when I select one particular manufacturer in cell B1, then in cell C1
it just show me product category produced by that particular manufacturer.

Then, continuing from previous step I select one product category from that
list (cell C1) and then it should give me products list under that category
in Cell D1.

Now, finally selecting an item from the product list in Cell D1, it should
pop up the username in Cell E1.

Now, as far as this username is concerned I know their combination......

So, what I want is that.... when particular city, manufacturer, category and
product is selected it gives me username in cell E1.

I hope that it is helpful for you....

I hope that sm1 can solve it....

thanks!!!!

 

[Keith]

Will this be interactive? If so, my first thought is to use Auto Filter.

City Mfr Category Product Concat
New York ny1 ny1c1 ny1c1p1 =A2 & "; " & B2 & "; " & C2 & "; " & D2
New York ny1 ny1c1 ny1c1p2
New York ny1 ny1c1 ny1c1p3
New York ny1 ny1c1 ny1c1p4
New York ny1 ny1c1 ny1c1p5
New York ny1 ny1c2 ny1c2p1
New York ny1 ny1c2 ny1c2p2
etc...

After entering the formula for E1, fill down for all rows. Highlight cells
A11, then click Data, Filter, AutoFilter. Drop-down lists appear. Make
your selections. The second row in column E now has the concatenated string
separated by '; '..

New York; ny1; ny1c1; ny1c1p3

hope that helps,
Keith

 

[mahendra2210]

Does no 1 can solve this problem!!!!!!!

Hey James,

Thanks for your response. But, unfortunately that's not I was looking for.

I'll rephrase my question:

"I have a distribution list of 5 cities in cell A1, 5 manufacturers in cell
B1, 5 products category in cell C1, and 5 product list in cell D1."

Now, I want that if I select one particular city in cell A1, then it should
give me options to select manufacturers available in that city only.

Again, when I select one particular manufacturer in cell B1, then in cell C1
it just show me product category produced by that particular manufacturer.

Then, continuing from previous step I select one product category from that
list (cell C1) and then it should give me products list under that category
in Cell D1.

Now, finally selecting an item from the product list in Cell D1, it should
pop up the username in Cell E1.

Now, as far as this username is concerned I know their combination......

So, what I want is that.... when particular city, manufacturer, category and
product is selected it gives me username in cell E1.

I hope that it is helpful for you....

I hope that sm1 can solve it....

thanks!!!!