B5
=IF(ISERROR(MATCH(LEFT(A5,LEN(A5)-1),Sheet2!B:B,)),99,INDEX(Sheet2!A:A,MATCH(LEFT(A5,LEN(A5)-1),Sheet2!B:B,)))
G5
=IF(ISERROR(MATCH(F5,Sheet2!H:H,)),"",INDEX(Sheet2!G:G,MATCH(F5,Sheet2!H:H,)))
使用道具 举报
解决了,谢谢!
如果B5再加一个IF函数,把其他之外的返回空值就更完美了
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-6-1 18:11 , Processed in 0.242821 second(s), 8 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.