=iferror(VLOOKUP(A4,[进货明细.xlsx]Sheet1!$A$1:$B$24,2,FALSE),0)
=IF(ISERROR(VLOOKUP(A4,[进货明细.xlsx]Sheet1!$A$1:$B$24,2,0)),0,VLOOKUP(A4,[进货明细.xlsx]Sheet1!$A$1:$B$24,2,0))