[注意]函入4期第8讲作业上交贴（1.2.3组）

海尔兄弟

游客，如果您要查看本帖隐藏内容请回复

</p><p></p><p>正确㊣！</p>

[此贴子已经被guideming于2009-12-3 17:10:15编辑过]

领风飞翔

[em01]

sxccb

=IF(COUNTIF(INDIRECT("'"&B4&"'!A1:A9"),C4),VLOOKUP(C4,INDIRECT("'"&B4&"'!A1:B9"),2,),"无此人")
=$C18>INDIRECT("'sheet2 '!G1")
=SUM(OFFSET(C35:G35,MATCH(B46,B36:B42,),)*(1+SUMIF(I35:I39,C35:G35,J35:J39)))
=INDIRECT(TEXT(MAX(IF($B$53:$I$62=ROW(A1),ROW($53:$62)*100+COLUMN(B:I))),"R0C00"),)
=OFFSET(INDIRECT("材料名称!B1"),MATCH(B98,INDIRECT("材料名称!A2:A14"),),,,COUNTA(OFFSET(INDIRECT("材料名称!B1"),MATCH(B98,INDIRECT("材料名称!A2:A14"),),,,8)))

vbyou127

56566356

vbyou127

56566356