Data validation from Entity: Value list

br8kwall

New Member
Joined
Jan 7, 2014
Messages
1
I'm not seeing this exact case in my search. The value I need to use for validation will be dynamically updated from a database in one LONG (thousands of values) list basically as TYPE|VALUE and the values may change often from the DB. But I don't want to have to create separate lists (say horizontally) for validation. For example the validation data would be like:

TYPE | VALUE
-----------------------
FRUIT | Apple
FRUIT | Orange
VEGGIE | Lettuce
VEGGIE | Carrot

What I'm hoping to find is way to set the range on a list validation almost like how SUMIF works with quasi SQL where clause. Ideally I could find a function(s) to put into the Source field of a list validation that would operate like =(select VALUE where TYPE="Fruit"). I'm not sure if this is a custom or list validation.
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,129,588
Messages
5,637,275
Members
416,963
Latest member
samfuge

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
Top