Forum Discussion

AR Forcke's avatar
AR Forcke
Copper Contributor
Dec 23, 2017

Auto-fill cells depending on selection from a drop down menu

What is the formula (IF? Lookup? ???) to use so that a cell will display a specific "text" based on the user's  answer selected from a drop-down list in the preceding cell? 

 

For instance, if cell A1 has a drop down list of food types ("Entree," "Side," "Desert," "Snack") and I want cell A2 to to show a short text description of the "Food of the day" for whichever of those categories a user selects, HOW DO I DO IT?  I've tried the IF formulas, but these only accommodate one TRUE value and one NOT TRUE value.  

 

Thanks in advance! 

Resources