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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine Formula and Data Validation List in a Single Cell ??
Try this as the source for the drop down list:
=IF(OR(Q14=19,Q14=21),AJ3,IF(OR(Q14=20,Q14=22),AJ4 ,AJ2:AJ7)) -- Biff Microsoft Excel MVP "monir" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine Formula and Data Validation List in a Single Cell ??
Perfect! Thank you.
"T. Valko" wrote: Try this as the source for the drop down list: =IF(OR(Q14=19,Q14=21),AJ3,IF(OR(Q14=20,Q14=22),AJ4 ,AJ2:AJ7)) -- Biff Microsoft Excel MVP "monir" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine Formula and Data Validation List in a Single Cell ??
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "monir" wrote in message ... Perfect! Thank you. "T. Valko" wrote: Try this as the source for the drop down list: =IF(OR(Q14=19,Q14=21),AJ3,IF(OR(Q14=20,Q14=22),AJ4 ,AJ2:AJ7)) -- Biff Microsoft Excel MVP "monir" wrote in message ... 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. |
Reply |
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 |