Dependent cells with data validation
Closed
ach@amx
-
Oct 5, 2010 at 09:05 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 5, 2010 at 10:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 5, 2010 at 10:02 AM
Related:
- Dependent cells with data validation
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to be offline in whatsapp when data is on - Guide
- Data transmission cable - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 5, 2010 at 10:02 AM
Oct 5, 2010 at 10:02 AM
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
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
