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 ...