| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a IF function in a validation list cell
I want to have an item on a validation cell automatically selected when an
item in another cell's list is selected. I kind of feel like it would be something like: =IF(COUNTIF(D9,"*Base*"),24, UNKNOWN COMMAND ). This would look for the word "Base" in the cell D9 and if true would select 24 from the list, and if false I want it to defer to the user's selection. Not even sure this can be done. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using IF function and validation/list | Excel Worksheet Functions | |||
| Using If Function with a Data Validation List | Excel Discussion (Misc queries) | |||
| IF Function/Validation List/Totals | Excel Worksheet Functions | |||
| List Validation and IF Function Problem | Excel Worksheet Functions | |||
| Using IF function and validation list | Excel Worksheet Functions | |||
Threaded Mode
