<p></p><p>第一题:3月=VLOOKUP(A2,数据源!A1:E7,5,0)</p><p> 1月=VLOOKUP(A2,数据源!A1:E7,3,0)</p><p>第二题:=VLOOKUP(A12,数据源!A1:E7,2,0)</p><p>顺便问一下,老师:公式在这里是不能复粘的吗?因为我复粘了,只出现下面的数字300.谢谢老师!</p><p><table cellspacing="0" cellpadding="0" width="92" border="0" xstr="" style="WIDTH: 69pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="92" style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 2944;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="92" height="19" xnum="" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 69pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><p><font face="宋体"></font> </p><p><font face="宋体" color="#9222dd" size="4"><strong>这个贴子的格式没有发对哦。第一个参数选择的不对,再想想。</strong></font></p></td></tr></tbody></table></p><p><table cellspacing="0" cellpadding="0" width="92" border="0" xstr="" style="WIDTH: 69pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="92" style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 2944;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="92" height="19" xnum="" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 69pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr></tbody></table></p>
[此贴子已经被紫映竹于2008-3-8 17:01:15编辑过] |