hyperlink（“#‘sheet1’!B“&row（b6）,”a“）

hyperlink（“#‘sheet1’!B“&row（b6）,”a“） sheee2中a1=INDIRECT("sheet1!B"&ROW()*1+5) =lookup(A1,sheet1!A:A,sheet1!B:B)中的A1是什么意思,sheet1!A:sheet1!B {=indirect("Sheet1!A"&row(1:16))},公式正解. =OFFSET(Sheet1!A$1,MAX(0,ROW()*10-11),) =OFFSET(Sheet1!A$1,R =IF(ROW(A1)>7,"",INDIRECT("sheet1!A"&ROW(A1)+COLUMN(A1)*7-7) IF(MOD(ROW(),5),"",INDIRECT("sheet1!a"&ROW()/5) ) 您好,看到您的回答, =OFFSET(Sheet1!$A$1,SMALL(IF(Sheet1!$A$2:$A$11=$A$1,ROW($A$1 =INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$A$1:$A$100=1,ROW($1:$100) =INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$D$2:$D$500="合约",ROW($A$2: =IF(MOD(ROW(),3)=0,"",IF(MOD(ROW(),3)=1,Sheet1!B$1,INDEX(She =INDEX(Sheet1!A:A,SMALL(IF(MATCH(rr,rr,)=ROW(rr),ROW(rr),4^8