发条橙子:
你好,很高兴为你解答:假设你上面举例的表格形式数据是在sheet1你的sheet2表B1输入=if($a1="","",index(sheet1!$A:$A,match($b1,sheet1!$B:$B,)))C1输入=if($a1="","",index(sheet1!$C:$C,match($b1,sheet1!$B:$B,)))D1输入=if($a1="","",index(sheet1!$D:$D,match($b1,sheet1!$B:$B,)))下拉公式。这样新表的A列可以输入产品名....