Please try this " =vlookup(A2,D2:E5,2,0)
After pasting formula, Delete A2, and select your common value,
next, Delete D2:E5, and select the table in which your data is. Make sure to select from the common value column.
Hit enter.
If problem not resolved, please share the excel file with me so that I can have a look and help you out.