=if(isna(vlookup(a1,sheet2!a:b,2,0)),"",vlookup(a1,sheet2!a:b,2,0)) ，下拉
B1=vlookup(A1,sheet2!A:B,2,0)
