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.

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.

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.

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.