F1=IF(ISNA(VLOOKUP(A1,Sheet1!A:C,3,0)),"",VLOOKUP(A1,Sheet1!A:C,3,0))按住填充柄下拉。如果表2A列数据都能找到匹配值，公式前半部分可省略：=LOOKUP(A1,Sheet1!A:C,3,0)
