| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What function to use? Data Validation or IF | Setting up and Configuration of Excel | |||
| Data validation combo box lookup | Excel Worksheet Functions | |||
| data validation - indirect function | Excel Discussion (Misc queries) | |||
| Lookup validation data | Excel Discussion (Misc queries) | |||
| Data Validation Function Help | Excel Worksheet Functions | |||
Linear Mode
