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:

Vendor	Model
A	5
B	2
B	1
C	4

<tbody>
</tbody>

Selected vendor B result 2, 1

It will return wrong result in this table:

Vendor	Model
A	5
B	2
C	4
B	1

<tbody>
</tbody>

Selectec vendor: B result 2, 4

It also does not sorts result alphabetically.

Thanks