将数据验证列表中的选定值替换为其他值

I have two tables in different sheets. The first one has two columns (Name and Abbreviated Name) and the second one has many columns one of them has data validation list for its cells based on the first column (Name) in the first table. What I want to do is: when I select a value from the drop down list I want it to be replaced with the corresponding value in the (abbreviated Name) column, how I can achieve that? I have two tables in different sheets. The firs