Lawiltshire
New Member
- Joined
- Oct 22, 2021
- Messages
- 1
- Office Version
- 2013
- Platform
- Windows
Hello ,
I have tried looking for the solution to this but I can’t seem to find one.
I have a table where in column c you can select Yes or No
In column d there is a dependent drop down list linked to value of the cells in column c.
What I want to do is have cells in column D auto populate “Acceptable” when a cell in column C is “Yes”.
I.e. C1 = Yes so D1 autopopulates Acceptable from the drop down.
I have tried vlookup in column d but this keeps being removed when other options are selected.
Hoping someone can help
Thanks
I have tried looking for the solution to this but I can’t seem to find one.
I have a table where in column c you can select Yes or No
In column d there is a dependent drop down list linked to value of the cells in column c.
What I want to do is have cells in column D auto populate “Acceptable” when a cell in column C is “Yes”.
I.e. C1 = Yes so D1 autopopulates Acceptable from the drop down.
I have tried vlookup in column d but this keeps being removed when other options are selected.
Hoping someone can help
Thanks