More than 1 list in Data Validation (Drop Down Box)

[stte]

I am trying to include 2 ranged name lists (Vegs and Fruit)

Vegs - Cabbage, Lettuce, Spinach

Fruit - Apple, Orange

I am trying to limit my cell value (through drop down box) that will only return only the above values.

But I can only put in 1 range name list!

Any bright idea?

 

[AnAnalyst]

Are you using VBA or plain old data validation?

If the latter then why not convert the foodstuffs to one list that has the food category placed adjacent?

Food Cat
Apple Fruit
Orange Fruit
...

The "Food" column could then be the named range for the dropdown, and if you want to categorise you can add another named range encompassing the food and cat columns to be using in a vlookup formula. These named ranges could be set up as dynamic named ranges to automatically update the lists if you want additional entries.