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 ce...
Haytham Amairah
Dec 24, 2017Silver Contributor
You have two ways to do that either Nested IF or VLOOKUP as shown in the below screenshot:
Please find the attachment.