在D1中输入或复制粘贴下列公式之一=VLOOKUP(A1,B:C,2,)=IF(COUNTIF(B:B,A1),VLOOKUP(A1,B:C,2,),"无此编号")=IFERROR(VLOOKUP(A1,B:C,2,),"无此编号")下拉填充
用VlookUp函数。=Vlookup(a1,b:c,2,False)
D1输入 =IF(A1=B1，C1，"")
