'1. 引号的问题，VBA中2个单引号表示单元格公式中的1个单引号，'2. & 符号问题，&前后要留空修改如下：Sheets("汇总").Cells(i, 9).FormulaArray = "=INDEX(INDIRECT((LEFT($C$4,LEN($C$4)-1)) & " & """!D:D""" & "),SMALL(IF(ISNUMBER(1/(MATCH(INDIRECT((LEFT($C$4,LEN($C$4)-1)) & " & """!D2:D2000""" & "),IF(原材料!B2:B2000=$E$4,原材料!D2:D2000),0)=ROW(INDIRECT((LEFT($C$4,LEN($C$4)-1)) ...
|
