How to auto-populate a drop down cell based on drop down value in another cell

[Lawiltshire]

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

 

[GazNicki]

In order to set the dependant list in column D, you will be setting the cell to validate the data based on the list. Therefore, you can't make this cell auto-populate with code as it's already functioning as a cell with data validation - as far as I know.

My way around this was to use Conditional Formatting to blank the cell off, and then introduce a new column in E with the auto-population if statement.