本文介绍了使用excel中的公式复制数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
请帮忙,我有这种情况。我不知道如何解决vlookup,如果有人可以指导我,这将是很大的帮助。 县状态状态计数都柏林在2 都柏林出1 都柏林关闭10 已完成关闭2 已完成5
第2页与
县经济经济体都柏林好成长23 都柏林平均15 didgal不好14我想要结果为
县状态状态计数经济EconomyCount 都柏林2个良好增长23 都柏林1平均15 都柏林关闭10 N / A 已完成关闭2不好14 donegal 5 N / A解决方案
考虑到您的 Sheet1 为
和 Sheet2 是
假设您是第一次匹配,则在 Cell D2 code> Sheet1 输入公式
= IF(COUNTIF($ A $ 2:$ A2,$ A2)= 1,INDEX(Sheet2!$ B $ 2:$ B $ 3,MATCH($ A2,Sheet2!$ A $ 2:$ A $ 3,0)),N / A)和单元格E2 Sheet1 输入以下公式
= IF(COUNTIF($ A $ 2:$ A2,$ A2)= 1,INDEX(Sheet2!$ C $ 2:$ C $ 3,MATCH($ A2,Sheet2!$ A $ 2:$ A $ 3,0)),)根据需要拖放/复制。见图片供参考。
Please help, I have this situation. I am not sure how to solve with vlookup, if anyone can guide me that would be great help.
County Status Status Count dublin In 2 dublin out 1 dublin closed 10 donegal closed 2 donegal in 5Sheet 2 with
County Economy EconomyCount dublin good growth 23 dublin average 15 donegal not good 14I want result as
County Status Status Count Economy EconomyCount dublin In 2 good growth 23 dublin out 1 average 15 dublin closed 10 N/A donegal closed 2 not good 14 donegal in 5 N/A解决方案
Considering your Sheet1 is as
and Sheet2 is
Assuming you are matching for the first occurrence, then in Cell D2 of Sheet1 enter the formula
=IF(COUNTIF($A$2:$A2,$A2)=1,INDEX(Sheet2!$B$2:$B$3,MATCH($A2,Sheet2!$A$2:$A$3,0)),"N/A")and in Cell E2 of Sheet1 enter the following formula
=IF(COUNTIF($A$2:$A2,$A2)=1,INDEX(Sheet2!$C$2:$C$3,MATCH($A2,Sheet2!$A$2:$A$3,0)),"")Drag/Copy down as required. See image for reference.
更多推荐
使用excel中的公式复制数据
发布评论