3 or more dependent lists in data validation

[Fatty1]

I need to create data validation using 3 lists - my items have ïllegal characters so I have tried using a Lookup table and that works for the first 2 lists but I amnot sure how to get the 3 set of list working? In Version 2007 any help would be appreciated

 

[Stan_C]

Can you post your data?

 

[Fatty1]

How do I paste it? sorry I'm a complete dummy

 

[Stan_C]

In my signature there is a add in that works very well or you could go to advanced post and create some tables with example data.

 

[Fatty1]

The Joy Cowley Collection - Original Series</SPAN> Set 1 - Small Books</SPAN> Set 1 - Big Books</SPAN> The Joy Cowley Collection - Original Series</SPAN> Set 1 - Small Books</SPAN> Dan, the Flying Man</SPAN> Dan, the Flying Man</SPAN> The New Joy Cowley Collection</SPAN> Set 1 - Big Books</SPAN> The Monsters' Party</SPAN> The Monsters' Party</SPAN> The Joy Cowley Club</SPAN> Set 2 - Small Books</SPAN> The Jigaree</SPAN> The Jigaree</SPAN> Wise Up!, Set 1</SPAN> Set 2 - Big Books</SPAN> Mrs Wishy-Washy</SPAN> Mrs Wishy-Washy</SPAN> Wise Up!, Set 2</SPAN> Set 3 - Small Books</SPAN> Smarty Pants</SPAN> Smarty Pants</SPAN> Signatures, Set 1</SPAN> Set 3 - Big Books</SPAN> Meanies</SPAN> Meanies</SPAN> Signatures, Set 2</SPAN> To Town</SPAN> To Town</SPAN> ODD Books</SPAN> Grandpa, Grandpa</SPAN> Grandpa, Grandpa</SPAN> Active Lives, Set A</SPAN> The Hungry Giant</SPAN> The Hungry Giant</SPAN> <TBODY> </TBODY><COLGROUP><COL span=4></COLGROUP>
Thank you!

<TBODY>
</TBODY>

 

[Stan_C]

I see your data. What is it your are looking to do with it?

 

[Fatty1]

Say you pick one item from the first list
Then you have the options from the 2nd list - I have managed to make that work using a Lookup table
but I cant add the 3 list once you have picked from the 2nd list - then you need to be able to pick from a third list that relates back to the 2nd list
Does that make sense - all the lists have illegal characters and more than one word
thank you for your patience !