excel **匹配

时间:2012.10.17 发布人:虎背熊腰当爹啦

excel **匹配

已解决问题

谷歌虎背熊腰当爹啦用户在2012.10.17提交了关于“天门山excel **匹配”的提问,欢迎大家涌跃发表自己的观点。目前共有2个回答,最后更新于2025-01-04T23:00:20。

表1:ABCD起始日期起始时间通话时长2012-03-3010:58:3400:01:462012-03-3011:22:0600:01:122012-03-3011:56:3700:00:532012-03-3014:03:0600:03:032012-03-3014:21:0400:00:152012-03-3014:29:2900:00:092012-03-3014:30:5000:00:162012-03-3014:37:5800:00:252012-03-3014:57:0600:00:152012-03-3015:03:1500:00:322012-03-318:10:4900:00:192012-03-318:12:4300:00:442012-03-318:16:1300:00:382012-03-319:07:5000:00:502012-03-319:10:1700:02:062012-03-319:31:3700:00:172012-03-3110:06:0800:01:052012-03-3110:11:3200:00:032012-03-3110:21:4400:03:01表二:ABC开始日期开始时间资费2012-3-3108:10:490.182012-3-3108:12:440.182012-3-3108:16:130.182012-3-3108:57:100.722012-3-3109:07:510.182012-3-3109:10:170.542012-3-3109:12:400.542012-3-3109:31:370.182012-3-3109:51:520.18首先匹配日期相同的,再在日期相同中匹配时间相同的,把表二c资费输出到表1D

希望大家能够帮助她。

详细问题描述及疑问:

表1:ABCD起始日期起始时间通话时长2012-03-3010:58:3400:01:462012-03-3011:22:0600:01:122012-03-3011:56:3700:00:532012-03-3014:03:0600:03:032012-03-3014:21:0400:00:152012-03-3014:29:2900:00:092012-03-3014:30:5000:00:162012-03-3014:37:5800:00:252012-03-3014:57:0600:00:152012-03-3015:03:1500:00:322012-03-318:10:4900:00:192012-03-318:12:4300:00:442012-03-318:16:1300:00:382012-03-319:07:5000:00:502012-03-319:10:1700:02:062012-03-319:31:3700:00:172012-03-3110:06:0800:01:052012-03-3110:11:3200:00:032012-03-3110:21:4400:03:01表二:ABC开始日期开始时间资费2012-3-3108:10:490.182012-3-3108:12:440.182012-3-3108:16:130.182012-3-3108:57:100.722012-3-3109:07:510.182012-3-3109:10:170.542012-3-3109:12:400.542012-3-3109:31:370.182012-3-3109:51:520.18首先匹配日期相同的,再在日期相同中匹配时间相同的,把表二c资费输出到表1D

期待您的答案,希望你能感受到,我最真诚的谢意 !
希望以下的回答,能够帮助你。

第1个回答

用户名:他大舅他封暴据自二舅都  

在sheet1的d带行立害2中写入公式:=lookup(1,0/((sheet2!$a$2:$a$100=a2)*(she专亚胶et2!$b$2:$b$100=b2)),sheet2!$c$2:$c$春吧100)下拉复制公式。

第2个回答

用户名:velhinho  

在s今状吃编银住田言三极heet1的d2中写入公式:=lookup(1,0/((sheet2!$a$2:$a$100=a2)*款(sheet2!$b$2:$b$100=b2)留会科间当均支边心),sheet2赵语激检往!$c$2:$c$100)下拉复制公式。