Forum Discussion
AR Forcke
Dec 23, 2017Copper Contributor
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!
1 Reply
- Haytham AmairahSilver Contributor
You have two ways to do that either Nested IF or VLOOKUP as shown in the below screenshot:
Please find the attachment.