excel 中使用VLOOKUP 函数是对比栏目是合并单元格,需要提取目标合并单 ...答:前面的表格为SHEET1 后面的表格为SHEET2 在SHEET1的D4单元格输入公式 =index(sheet2!D:D,match(b4,sheet2!B:B,0)+1)下拉填充即可 如果需要纠错,可以使用公式 =iferror(index(sheet2!D:D,match(b4,sheet2!B:B,0)+1),"")如果SHEET2的姓名是唯一的,还可以使用SUMIF函数 =sumif(sheet2!
EXCEL中将多个单元格内容合并到一个单元格并其中一项内容为空的则不显 ...答:按你发来的表,公式:=IF(D3="","",D$2&D3&",")&IF(E3="","",E$2&E3&",")&IF(F3="","",F$2&F3&",")&IF(G3="","",G$2&G3&",")&IF(H3="","",H$2&H3+I3&",")&IF(J3="","",J$2&J3+K3&"