使用excel中的公式复制数据

请帮忙，我也有这样的情况。我不确定如何使用 vlookup 解决问题，如果有人可以指导我，那将是很大的帮助。

County  Status  Status Count
dublin  In      2   
dublin  out     1
dublin  closed  10
donegal closed  2
donegal in      5

表 2 与

County  Economy     EconomyCount
dublin  good growth  23
dublin  average      15
donegal not good     14

我想要的结果是

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

考虑到您的Sheet1 is as

and Sheet2 is

假设您匹配第一次出现，那么在Cell D2 of Sheet1输入公式

=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输入以下公式

=IF(COUNTIF($A$2:$A2,$A2)=1,INDEX(Sheet2!$C$2:$C$3,MATCH($A2,Sheet2!$A$2:$A$3,0)),"")

根据需要向下拖动/复制。请参阅图片以供参考。