在EXCEL中=IF(ISERROR(VLOOKUP(M3,B:C,2,0))

2025-03-05 02:27:52
推荐回答(1个)
回答1:

=IF(ISERROR(VLOOKUP(M3,B:D,3,0)),"",VLOOKUP(M3,B:D,3,0))
或引用E列用下面
=IF(ISERROR(VLOOKUP(M3,B:E,4,0)),"",VLOOKUP(M3,B:E,4,0))