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

stte

New Member
Joined
Feb 1, 2007
Messages
16
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?
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
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.
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,266
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top