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 339 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 response

MaxStart Posts 339 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