# How to make a column equal one of many possibilities based on text in another column.

• ### Question

• Basically I want to do this. If Column 1 = "Text" (The "Text" is going to be selected from a dropdown that may have 10 items for that column), THEN Column 2 = Result (Result will be one or more items that will show in the result column).

Example:

If Column 1 Text = Daily, Then Column 2 = Trash Cans and Windows, BUT If Column 1 Text = Monthly, Then Column 2 = Wash Dishes BUT If Column 1 = Yearly, Then Column 2 = Vacuum Carpet

This should be so simple, But I cannot figure it out. I know I will be using a calculated column.

Thanks

Friday, October 7, 2011 2:22 PM

• Hi,

You can try the following formulas in column 2:

=IF([Column 1]="Daily", "Trash Cans and Windows", IF([Column 1]="Monthly", "Wash Dishes", IF([Column 1]="Yearly", "Vacuum Carpet", "Please enter daily, Monthly or Yearly")))

Hope this helps.

Thanks,

Pengyu Zhao

• Marked as answer by Friday, October 14, 2011 2:07 AM
Monday, October 10, 2011 3:22 AM
• HI,

This can be done using calculated columns.

Create a formula for the same and apply to your column.

Thanks, Rahul Rashu
• Marked as answer by Friday, October 14, 2011 2:07 AM
Monday, October 10, 2011 3:31 AM

### All replies

• Hi,

You can try the following formulas in column 2:

=IF([Column 1]="Daily", "Trash Cans and Windows", IF([Column 1]="Monthly", "Wash Dishes", IF([Column 1]="Yearly", "Vacuum Carpet", "Please enter daily, Monthly or Yearly")))

Hope this helps.

Thanks,

Pengyu Zhao

• Marked as answer by Friday, October 14, 2011 2:07 AM
Monday, October 10, 2011 3:22 AM
• HI,

This can be done using calculated columns.

Create a formula for the same and apply to your column.

Thanks, Rahul Rashu
• Marked as answer by Friday, October 14, 2011 2:07 AM
Monday, October 10, 2011 3:31 AM