Struggling with dependent text or list display in cell

Closed
leecey1
Posts
1
Registration date
Thursday May 7, 2015
Status
Member
Last seen
May 7, 2015
- May 7, 2015 at 03:18 PM
MaxStart
Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
- May 8, 2015 at 08:45 AM
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

MaxStart
Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
May 8, 2015 at 08:45 AM
=IF(A1="Value-1","picked Value-1",IF(A1="Value-2","picked Value-2",IF(A1="Value-3","picked Value-3","not listed")))

0