Dropdown list dependent

[eduzs]

Hi all,
I need to populate a drop down list in a cell based on the value of another cell.
If type in A1 cell "Fruits", in B1 it only lists "Apples, Lemons,..." of vegetables lists.
Thanks

 

[gallen]

There is a handy tutorial here. I assume that is what you mean?

 

[hiker95]

eduzs,

See if the following link will help you.

http://www.mrexcel.com/forum/excel-questions/768677-create-dynamic-drop-down-list.html

 

[eduzs]

Thanks.
I have this formula (list / data validation formula) that works IF the 1st column "A" is sorted alphabetically, lists "B" column in order of appearance.
=OFFSET($A$1,MATCH($J4,$A:$A,0)-1,1,COUNTIF($A:$A,$J4))
I want a formula that auto sort alphabetically and that works in non continuous A$ list ("A,B,D,E,A,A,B,D,B,B").
The above formula works in a table like that:
[TABLE="width: 100"]
<tbody>[TR]
[TD]Vendor[/TD]
[TD]Model[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

Selected vendor B result 2, 1

It will return wrong result in this table:

[TABLE="width: 100"]
<tbody>[TR]
[TD]Vendor[/TD]
[TD]Model[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

Selectec vendor: B result 2, 4

It also does not sorts result alphabetically.

Thanks