使用道具 举报
Book4.rar
2012-6-17 00:32 上传
点击文件名下载附件
1.78 KB, 下载次数: 21
lzclzch 发表于 2012-6-17 00:32 =IF(COUNTIF($B$6:$B$9,H6)>0,VLOOKUP(H6,$B$6:$D$9,3,FALSE),VLOOKUP(H6,$C$6:$D$9,2,FALSE))
qingfeng_qf 发表于 2012-6-17 08:13 =INDEX(D:D,SUM((($B$6:$B$9=H12)+($C$6:$C$9=H12))*ROW($6:$9)))
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-19 10:12 , Processed in 0.303053 second(s), 9 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.