| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine Formula and Data Validation List in a Single Cell ??
Hello;
a) Cell C7 has a drop-down list of 6 values (data source AJ2:AJ7): .....3 .....4 .....5 .....6 .....7 .....8 b) I need to impose a restriction on the selection such that: IF the value in cell Q14 is 19 or 21, THEN the value in C7 should ONLY be 4 IF the value in cell Q14 is 20 or 22, THEN the value in C7 should ONLY be 5 ELSE any selected value from the list is valid. Is there a way of doing that ?? Your help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA WITH A CELL THAT HAS A DATA VALIDATION LIST IN IT | Excel Worksheet Functions | |||
| combine the two into a single formula please | Excel Worksheet Functions | |||
| HELP: Data > Validation ---List ----Formula | Excel Worksheet Functions | |||
| How do I combine tabulated data into a single column and list alphabetically? | Excel Discussion (Misc queries) | |||
| how to add two data validation lists to a single cell? | Excel Worksheet Functions | |||
Threaded Mode
