[hide][/ <p>第一题:A4输入D4,A5输入D4</p><p> A7=INDIRECT(A4)</p><p> A8=INDIRECT(INDIRECT("r5c1",0))</p><p> A10=INDIRECT("D4")</p><p> A11=INDIRECT("r4c4",)</p><p>第二題:A24=INDIRECT("R"&RIGHT(A24)+17&"C5",)</p><p>第三題:C37=IF(ISNA(VLOOKUP(B37,INDIRECT("'"&A37&"'!A:B"),2,0)),"",VLOOKUP(B37,INDIRECT("'"&A37&"'!A:B"),2,0))</p><p><br/>replyview]作业不会做晕啊,在同学的帮助下做的不知对不对,老师辛苦了。</p><p><strong><font face="Verdana" color="#61b713">算通过,1题2问有点问题</font></strong></p>
[此贴子已经被zbhpass于2008-7-29 10:44:22编辑过] |