[练习题]【综合1系(2期)1班】第十讲作业上交贴(9组)

hzhxw5570

<p><font color="#3d11ee" size="3">请9组同学在此跟帖上交作业，作业采取回复贴方式！ </font></p><p><font color="#3d11ee" size="3">注意： 1、如果不采取回复贴方式，班级将采取惩罚措施！ </font></p><p><font color="#3d11ee" size="3">2、请不要回复与作业无关的内容 </font></p><p><font color="#3d11ee" size="3">3、请不是我班或本组的 学员不要跟帖，以便于组长统计与管理，谢谢大家的支持和配合</font></p><p><font color="#3d11ee" size="3">&nbsp;4、作业上交后请不要编辑贴子</font></p>

[此贴子已经被作者于2008-9-28 22:12:55编辑过]

ease12

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

</p><p>&nbsp;</p><p>[/hide]</p><p>1.=VLOOKUP($D$8,$C$3:$H$5,MATCH(C9,$C$3:$H$3,0),FALSE)<br/>2.=INDEX($C$3:$H$5,MATCH($D$8,$C$3:$C$5,0),MATCH(C9,$C$3:$H$3,0))<br/>3.=HLOOKUP(C9,$C$3:$H$5,MATCH($D$8,$C$3:$C$5,0),FALSE)<br/>4.=OFFSET($C$3,MATCH($D$8,$C$4:$C$5,0),MATCH(C9,$D$3:$H$3,0))</p>

KLMYGGN

<table cellspacing="0" cellpadding="0" width="357" border="0" xstr="" style="WIDTH: 267pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="119" style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4352;"></col><col span="2" width="119" style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4352;"></col></colgroup><tbody><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl64" width="119" height="21" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 89pt; BORDER-BOTTOM: #ffffff; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow" size="2">1=VLOOKUP(C5,$C$3:$H$5,MATCH(C9,$C$3:$H$3,0),0)</font></td><td class="xl63" width="119" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 89pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow" size="2"></font></td><td class="xl63" width="119" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 89pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow" size="2"></font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl64" height="21" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow" size="2">2..=INDEX($C$3:$H$5,MATCH(C5,$C$3:$C$5,0),MATCH(C9,$C$3:$H$3,0))</font></td><td class="xl63" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow" size="2"></font></td><td class="xl63" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow" size="2"></font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl64" height="21" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow" size="2">3..=HLOOKUP(C9,$C$3:$H$5,MATCH(C5,$C$3:$C$5,0),0)</font></td><td class="xl63" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow" size="2"></font></td><td class="xl63" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow" size="2"></font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl64" height="21" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow" size="2">4..=OFFSET($C$3,MATCH(C5,$C$4:$C$5,0),MATCH(C9,$D$3:$H$3,0))</font></td><td class="xl63" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"></td><td class="xl63" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"></td></tr></tbody></table>

什么也不懂

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

<p>1,=VLOOKUP(D8,C4:H5,ROW(2:6),)&nbsp;&nbsp; 数组</p><p>2,=HLOOKUP(D8,TRANSPOSE(C4:H5),ROW(2:6),)&nbsp; 数组</p><p>3,=INDEX(INDEX(D4:H5,,ROW(1:5)),MATCH(D8,C4:C5,))&nbsp; 数组</p><p>4,=LOOKUP(D8,D8,OFFSET(INDEX(C4:C5,MATCH(D8,C4:C5,)),,ROW(1:5)))&nbsp; 数组</p><p>5,=OFFSET(OFFSET(INDEX(C4:C5,MATCH(D8,C4:C5,)),,ROW(1:5)-1),,1)&nbsp; 数组</p>[/hide]

SS1011

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

feiti

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

</p><p>呵呵，交作业了，10.1玩的差点忘了</p>

vbyou127

8565985556