=OFFSET(Sheet1!$B$2,8*$F$2-8,

=OFFSET(Sheet1!$B$2,8*$F$2-8, =OFFSET(sheet1!$C$1:$R$1,--(sheet2!$P$6)*8,sheet2!$B$2+0)这个是 =OFFSET(Sheet1!$A$1,SMALL(IF(Sheet1!$A$2:$A$11=$A$1,ROW($A$1 =OFFSET(Sheet1!A$1,MAX(0,ROW()*10-11),) =OFFSET(Sheet1!A$1,R OFFSET(Sheet1!B2,0, 在Excle表格中,这条公式“=VLOOKUP(A1,[Sheet1]Sheet1!A:B,2, 关于offset函数,在一个表中设定date=offset(sheet1!$C$4,counta(sheet1!$c:$ =OFFSET(Sheet1!$A$1,MATCH(C2763,Sheet1!$E:$E,)-1,MATCH(D2763 =SUMIF(BM!$C$2:OFFSET(BM!$C$2,0,$B$2-1),OFFSET(BM!$C$2,0,$B$ VLOOKUP(A40,Sheet1!A:B,2, =lookup(A1,sheet1!A:A,sheet1!B:B)中的A1是什么意思,sheet1!A:sheet1!B excel vba 咱刚入门 sheet1.cells(a,2)=sheet2.cells(1,b) b是1到8 a是1