第2个回答 2021-08-10
在SHEET2的D2中输入或复制粘贴下列公式之一
=INDEX(sheet1!A:K,MATCH(B2,sheet1!A:A,),MATCH(C2,sheet1!1:1,))
=VLOOKUP(B2,sheet1!A:K,MATCH(Sheet2!C2,sheet1!$1:$1,))
=HLOOKUP(C2,sheet1!$1:$100,MATCH(Sheet2!B2,sheet1!A:A,))
=INDEX(OFFSET(sheet1!B$1:K$1,MATCH(B2,sheet1!A:A,)-1,),MATCH(C2,sheet1!$1:$1,)-1)
=INDEX(OFFSET(sheet1!A:A,,MATCH(C2,sheet1!$1:$1,)-1),MATCH(B2,sheet1!A:A,))
下拉填充
第3个回答 2021-08-10
SHEET2的D2单元格中输入
=INDEX(Sheet1!A:K,MATCH(B2,Sheet1!A:A,0),MATCH(C2,Sheet1!1:1,0))
第4个回答 2021-08-10
=OFFSET(SHEET1!A1, MATCH(B2, SHEET1!A:A,0), MATCH(C2,SHEET1!1:1,0))