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
A1:D1, 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" wrote:

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""????