EXCEL中怎么根据一两个值提取所有相关内容到指定单元格中?答:Sheet2表的C6单元格输入公式=IFERROR(INDEX(OFFSET(Sheet1!$A$2:$A$100,,MATCH(IF(COLUMN()=3,"客户名称","客户编码"),Sheet1!$1:$1,)-1),SMALL(IF((Sheet1!$B$2:$B$100=$C$2)*(Sheet1!$F$2:$F$100=$C$3),ROW($2:$100)-1),ROW(A1))),"")数组公式,Ctrl+Shift+...