How to auto update the cell values based on list validation data

I want to know if there's a way to auto update the value cell from a list (query with data validation), because there will be cases in where an item is used in many rows and it's difficult to change it manually cell by cell.

I use list as my data criteria for data validation to make the dropdown list: 

=INDIRECT("Dropdown_Table[Dropdown List]")

- Original dropdown list

Original Values

- When a cell value change (in Dropdown List) the values doesn't change automatically

When a single value change