你好,在EXCEL中的公式如下=VLOOKUP(A4,[进货明细.xlsx]Sheet1!$A$1:$B$24,2,FALSE),

没有数据的单元格显示为0,公式应该如何?
2025-04-02 03:00:11
推荐回答(2个)
回答1:

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

回答2:

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