View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chantelle Chantelle is offline
external usenet poster
 
Posts: 6
Default Drop Down & V Lookup

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