EXCEL同样一个客户两行数据怎么合并到一起?答:VLOOKUP($A10,$A3:$I4,COLUMN(B:B),)="",INDEX(B3:B4,MATCH($A10,$A3:$A4,)+1),VLOOKUP($A10,$A3:$I4,COLUMN(B:B),))或=IF(VLOOKUP($A10,$A3:$I4,COLUMN(B:B),)="",LOOKUP(1,0/($A$3:$A$4=$A$10),B3:B4),VLOOKUP($A10,$A3:$I4,COLUMN(B:B),))下拉填充 ...