Struggling with dependent text or list display in cell [Closed]

Report
Posts
1
Registration date
Thursday May 7, 2015
Status
Member
Last seen
May 7, 2015
-
Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
-
Hi - thanks for reading

I'm not sure if this is possible but I'd like to get the following to work:
- Cell A1 contains a small pick from list
- The response in A1 triggers either of the following in B1
1) text ('Not applicable' for example); or
2) a different pick from list.

Have tried everything I can think of so any help at all would be appreciated!

Thanks

Jon

1 reply

Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
66
=IF(A1="Value-1","picked Value-1",IF(A1="Value-2","picked Value-2",IF(A1="Value-3","picked Value-3","not listed")))

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!