Dec 23 2017 02:55 PM
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!
Dec 23 2017 07:42 PM
You have two ways to do that either Nested IF or VLOOKUP as shown in the below screenshot:
Please find the attachment.