=OFFSET(Sheet1!$A$1,Sheet1!$E$1-1,

=OFFSET(Sheet1!$A$1,MATCH(C2763,Sheet1!$E:$E,)-1,MATCH(D2763 =OFFSET(Sheet1!A$1,MAX(0,ROW()*10-11),) =OFFSET(Sheet1!A$1,R =OFFSET(Sheet1!$A$1,SMALL(IF(Sheet1!$A$2:$A$11=$A$1,ROW($A$1 =OFFSET(Sheet1!$A$1,4-COLUMN(A1),),请解释一下公式的使用, =IF（A1="","",VLOOKUP（A1,SHEET1!$A$1：$E$10,COLUMN（B1）,FALSE） =INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$A$1:$A$100=1,ROW($1:$100) {=indirect("Sheet1!A"&row(1:16))},公式正解. =OFFSET(sheet1!$C$1:$R$1,--(sheet2!$P$6)*8,sheet2!$B$2+0)这个是 OFFSET(Sheet1!B2,0, 英语翻译="("&LOOKUP(0,-1/COUNTIF(Sheet1!C2:N2,Sheet1!C2:N2),Shee =INDEX(sheet1!H:H,small(if(sheet1!Y$1:Y$100 =lookup(A1,sheet1!A:A,sheet1!B:B)中的A1是什么意思,sheet1!A:sheet1!B