=IF(ISNA(VLOOKUP(D2,$A$2:$B$45,2,FALSE)),0,VLOOKUP(D2,$A$2:$B$45,2,FALSE))
excel匹配
最新推荐文章于 2021-06-30 21:20:11 发布
=IF(ISNA(VLOOKUP(D2,$A$2:$B$45,2,FALSE)),0,VLOOKUP(D2,$A$2:$B$45,2,FALSE))