Data Validation for 3 columns

[nikhil_715]

[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD]TOM
[/TD]
[TD]CANADA
[/TD]
[TD]PANCAKE
[/TD]
[/TR]
[TR]
[TD]MACK
[/TD]
[TD]ENGLAND
[/TD]
[TD]HOTDOG
[/TD]
[/TR]
[TR]
[TD]HARDY
[/TD]
[TD]USA
[/TD]
[TD]BURGER
[/TD]
[/TR]
[TR]
[TD]TOM
[/TD]
[TD]CHINA
[/TD]
[TD]MOMOS
[/TD]
[/TR]
[TR]
[TD]MICK
[/TD]
[TD]CANADA
[/TD]
[TD]PIZZA
[/TD]
[/TR]
</tbody>[/TABLE]
Hi, I have 3 columns , in column A I have around 220 line items which are unique words, in column B there are 433 line items which are unique. All the items in one or the other form in column A are linked to each items in B. (Example I have Tom in column a which has further 2 items which are linked in column B ) and similarly column B is further linked up with column C which has another 1646 line items. I want to validate cells in such a way that when I select from column A drop list , the other cell for column B should only show me the items in the drop list which are related to column A (Ex if I select TOM from the drop list the other list should only allow me to select CANADA ,CHINA in the drop box) further in the third cell it should only allow me to select options which are linked to column B ,in the above case I selected TOM I get to select CANADA OR CHINA then I select CANADA it should allow me to only select from PANCAKE or PIZZA. This is a small example Pancakes might also be linked to another country or name .

The lines are in 1000s so its difficult for me to sort out the list in a new tab like the easy way where you List first column then under each name sorting out the country and then the food.

Thank you in advance

 

[DanteAmor]

Review this:

https://www.contextures.com/xlDataVal02.html

 

[nikhil_715]

Review this:

https://www.contextures.com/xlDataVal02.html

Thank you for the reply but what I see in your site that you have sorted the tables with the headers but in my case I cant sort them or arrange them.

 

[DanteAmor]

That is the way for the dependents. The other option is to create a userform with combobox

 

[MickG]

Another option:-
https://app.box.com/s/1fte2temwmlh6lvytnh6jwdg3eo9c3dd

 

[nikhil_715]

Another option:-
https://app.box.com/s/1fte2temwmlh6lvytnh6jwdg3eo9c3dd

This is great but on the other hand I cant drag the rows down , it works for the first row perfectly but once I drag the first row it doesn't work for the rest of the rows accept for the 1 row.

 

[MickG]

Do you mean if you have 100 unique items in your data sheet column "A" then you would like 100 rows just like the single row you have now on sheet1, so you could make multi sections, or something different please explain !!

 

[nikhil_715]

Do you mean if you have 100 unique items in your data sheet column "A" then you would like 100 rows just like the single row you have now on sheet1, so you could make multi sections, or something different please explain !!

Yes my column A has 219 unique rows I want the drop box in all 219 cells in column A and the other column b n c should be dependent with the drop box

 

[nikhil_715]

Do you mean if you have 100 unique items in your data sheet column "A" then you would like 100 rows just like the single row you have now on sheet1, so you could make multi sections, or something different please explain !!

Hi by any chance is there a solution for my problem.

 

[MickG]

Try this example:-
You will need to change sheet2 for your new data , Then close and reopen the workbook.
https://app.box.com/s/9ph1klbnhxhum0gekevmgh1s3pqo4sxs