Dependent cells with data validation

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,
I have let's say cell c18 include a validation list with choices Y,N. Then in Cell c19, I need it to read "0" if cell c18 is "N", but I need a validation list if cell c18 reads "Y". How do I get the validation list to appear dependent on cell c18 being a "Y"?


1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi ach@amx,

I made up my sheet like this:
A1 = Y
A2 = N
B1 = 1
B2 = 2
B3 = 3

Note: Data in range B1:B3 is random.

Then I went to C18, top menu's - data - validate - list, select range A1:A2.
Then I went to C19 and entered the formula: =IF(C18="N",0,"").
Still keeping cell C19 selected, top menu's - data - validate - list,
=IF($C$18="Y",$B$1:$B$3,"").

Does this answer your question?

Best regards,
Trowa