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

Question

Previous Topic Next Topic

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

Report

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

Struggling with dependent text or list display in cell
Excel data validation list display two columns - How-To - Excel
Excel - Create drop down list on certain cells - How-To - Excel
Specific price depending on the words in 2 cells? please help ✓ - Forum - Excel
Create drop down list on certain cells ✓ - Forum - Excel
Excel Formula Display in Cell ✓ - Forum - Excel

1 reply

Ask a question

MaxStart · Answer 1 · 2015-05-08T08:45:15-0400

Answer 1 / 1

MaxStart

Posts: 341
Registration date: Tuesday March 3, 2015
Status: Moderator
Last seen: July 3, 2015

66
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")))

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

1 reply

Your reply

Subscribe To Our Newsletter!