Ask Your Question
0

Data Validity feature

asked 2018-04-12 11:57:10 +0200

Prabha gravatar image

I need help in data validity feature. If value of A1 is X, then B1 should display a value; if value of A1 is Y, then B1 should display a different value. For all other values, B1 should display as N/A. Please help.

edit retag flag offensive close merge delete

Comments

This doesn't look as if it is actually about Data > Validity.
=IF(A1="X";Xvalue;IF(A1="Y";Yvalue;NA())) in cell B1 should do.

Lupp gravatar imageLupp ( 2018-04-12 13:30:08 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-04-12 13:36:36 +0200

Lupp gravatar image

updated 2018-04-12 13:39:00 +0200

If you actually want to get different "DropDownLists" for B1 depending on the content of A1:
Put the alternative lists into different cell ranges, choose the option Cell range in the validity dialogue, and enter into the range field a formula like
IF(A1="X";$Sheet1.$A$11:$A$20;IF(A1="Y";$Sheet1.if$A$21:$A$30;NA())).
Data > Validity accepts calculated ranges.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-04-12 11:57:10 +0200

Seen: 30 times

Last updated: Apr 12 '18