Lookup Function for Data Validation
 

I have a sheet which I want to use as a source for some data validation
drop-down lists on another sheet;

e.g.

Category Product
Fruit Apple
Fruit Orange
Fruit Pear
Vegetables Onion
Vegetables Pepper
Vegetables Potato
Vegetables Carrot

Is there a formula I can put into the {Data Validation} - {List} - {List
Source} box which will only list the Products in the 'Vegetables' category?

Thanks

Nick

Lookup Function for Data Validation
 

http://www.contextures.com/xlDataVal02.html

Contextures has a full write up on this type of validation.

"NH" wrote:

I have a sheet which I want to use as a source for some data validation
drop-down lists on another sheet;

e.g.

Category Product
Fruit Apple
Fruit Orange
Fruit Pear
Vegetables Onion
Vegetables Pepper
Vegetables Potato
Vegetables Carrot

Is there a formula I can put into the {Data Validation} - {List} - {List
Source} box which will only list the Products in the 'Vegetables' category?

Thanks

Nick

Lookup Function for Data Validation
 

Perfect, thank you..


"klswvu" wrote:

http://www.contextures.com/xlDataVal02.html

Contextures has a full write up on this type of validation.

"NH" wrote:

I have a sheet which I want to use as a source for some data validation
drop-down lists on another sheet;

e.g.

Category Product
Fruit Apple
Fruit Orange
Fruit Pear
Vegetables Onion
Vegetables Pepper
Vegetables Potato
Vegetables Carrot

Is there a formula I can put into the {Data Validation} - {List} - {List
Source} box which will only list the Products in the 'Vegetables' category?

Thanks

Nick