在SHEET1的C2中输入或复制粘贴下列公式=INDEX(SHEET2!B$2:E$5,MATCH(J2,SHEET2!A$2:A$5,),MATCH(A2&B2,SHEET2!B$1:E$1,))或=INDEX(SHEET2!B$2:E$5,MATCH(J2,SHEET2!A$2:A$5,1),MATCH(A2&B2,SHEET2!B$1:E$1,))下拉填充
