怎样将excel中的一个单元格的内容引用到另一个excel中两个单元格里答:Sheet1 Sheet2 E4=IF(MOD(ROW(A1),2),LEFT(INDEX(Sheet1!$D$3:$H$4,ROUNDUP(ROW(A1)/2,0),COLUMN(A1)),FIND("(",INDEX(Sheet1!$D$3:$H$4,ROUNDUP(ROW(A1)/2,0),COLUMN(A1)))-2),MID(INDEX(Sheet1!$D$3:$H$4,ROUNDUP(ROW(A1)/2,0),COLUMN(A1)),FIND("(",...