=IF(ISERROR(VLLOKUP($A2，Sheet2！ $A$2:$B$200，2，0)，""，VLLOKUP(A2，Sheet2！ $A$2:$B$200，2.0))
Format Handle Drop-down List Copy Formula
Sheet2！ $ A $2: $ B $200 is the cell range where the names and corresponding data in Table 2 are located.