Struggling with dependent text or list display in cell
Closed
leecey1
MaxStart
- Posts
- 1
- Registration date
- Thursday May 7, 2015
- Status
- Member
- Last seen
- May 7, 2015
MaxStart
- Posts
- 341
- Registration date
- Tuesday March 3, 2015
- Status
- Moderator
- Last seen
- July 3, 2015
Related:
- Struggling with dependent text or list display in cell
- Multi row dynamic dependent drop down list in excel - Guide
- Excel drop down list changes other cells ✓ - Forum - 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
MaxStart
May 8, 2015 at 08:45 AM
- Posts
- 341
- Registration date
- Tuesday March 3, 2015
- Status
- Moderator
- Last seen
- July 3, 2015
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")))
