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

Copper Contributor

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! 

1 Reply

You have two ways to do that either Nested IF or VLOOKUP as shown in the below screenshot:

Two Examples.PNG

 

Please find the attachment.