Hi

The easyest way:

Create a sheet Suppliers, where column headers are your categories, and in
every category column are listed suppliers for this category. P.e. from A1:
No Category1 Category2 Category3
Supplier1 Supplier1 Supplier1
Supplier2 Supplier3 Supplier2
Supplier3 Supplier4
Supplier5
, where into cell A2 you enter the formula
=IF(COUNTA($B2:$AX2)0,ROW()-1,"")

Define named range
Categories=OFFSET(Suppliers!$B$1,,,1,COUNTA(Suppli ers!$B$11:$AX$1))
(you use this named range to create your category selection drop-down,
i.e. )

Define named range
Suppliers=OFFSET(Suppliers!$A$1,1,1,MAX(Suppliers! $A:$A),COUNTA(Categories))

Activate the sheet with your main data. Let's assume the sheet has name
Data, and you have category in column A and Supplier in column B, with row
no 1 as header row. Select cell B2, and now define a named range
CatSuppl=OFFSET(Suppliers!$A$1,1,MATCH(Data!$A2,Ca tegories,0),COUNTA(INDEX(Suppliers,,MATCH(Data!$A2 ,Categories,0)),1))

Now create drop-downs for cells Data!A2 and Data!B2, using named ranges
Categories and CatSuppl respectively, and copy both cells down for as much
rows as you need.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Chantelle" wrote in message
...
Still on my restaurant menu database and I can think of what I want it do
but
am unsure of what the commands are in excel!
I have one dependent list which looks up the category and then returns
only
the ingredients from that category. Now I would like a second dependent
lookup that looks up the category and returns only the suppliers that
supply
the products in that category. Currently it keeps returning the first
dependency. Any suggestions?
Chantelle