Creating combinations of strings from lists

[jmarkus]

I have a bunch of lists: lista, listb, listc, listd

I would like to generate a string which is a concatenation of all combinations of these lists, for example:

lista(item1)_listb(item1)_listc(item1)_listd(item1)
...
...
...
lista(itemn)_listb(item1)_listc(item1)_listd(item1)
...
...
...
lista(itemn)_listb(itemn)_listc(itemn)_listd(itemn)

How can I get Excel to help me do this?

Thanks,
Jeff

 

[ivymike]

assign numbers to each list item in each column
make a table that contains all of the combinations of list item numbers(in separate columns)
use the index() function to pick strings and & to concatenate

example:
___A__B__C__D__E__F__G__H
1| 1 1 1 1 sd asf ae sdf
2| 2 1 1 1 ert qw pu dut
3| 4 1 1 1 sd aer fd awer
4| 1 1 1 2 we qwe fd asr

=index($E$1:$H$4,A1,1)&"_"&index($E$1:$H$4,B1,2)&"_"&index($E$1:$H$4,C1,3)&"_"&index($E$1:$H$4,D1,4)

the above eqn should give sd_asf_ae_sdf if I typed it all correctly