creating a table composed from few lists

[amitc4u]

I want to creat a table containing the values of three diferent lists that has constant values.
For each value from list A I want to assign all the values from List B (in the next column) and for each value from list B I want to assign the List from List C.
Phase 2
the next phase is to assign values from a specific list depending the value in the list A

 

[Luke M]

I'm not sure if I understood Phase 2 correctly, but these formula examples should help you out.

 

[amitc4u]

you understood just fine and it's working very well.
thank's!!
wouldn't it be more correct to do it with macro that would produce the table with a button when the finished editing the lists ?

again, thank's a lot!

 

[Luke M]

You could do it with a macro, certainly. The formulas I setup though are designed to be pretty flexible. Right now, they all use Named Ranges. Those named ranges are currently static (don't change) but you could make them dynamic easy enough, allowing you to edit the different lists.

 

[SirJB7]

Hi, amitc4u!
My two cents. If you usually perform these list buildings maybe you want to give a look at the uploaded file. It uses no ranges at all (avoiding creating/changing name definitions).
Regards!