我的公式错在哪里呀

jasonforliu

<p> liZdwCzo.rar (7.84 KB, 下载次数: 11)

2008-3-4 13:49 上传

点击文件名下载附件
我的公式错在哪里呀

<br/>[em04]</p><p></p><p>请问我的公式错在哪里呀？谢谢</p>

Jdtax

<p>VLOOKUP(A4,<font color="#ff0000">过单明细表!$E$4:$E$44</font>,<font style="BACKGROUND-COLOR: #0066ff;">2</font>,0)</p><p><font color="#ff0000">过单明细表!$E$4:$E$44</font>只有一列，你却要求在第二列查找</p>

zengyutang

<p><table cellspacing="0" cellpadding="0" width="273" border="0" style="WIDTH: 205pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="273" style="WIDTH: 205pt; mso-width-source: userset; mso-width-alt: 9984;"></col></colgroup><tbody><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl22" width="273" height="17" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 205pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><div style="MIN-HEIGHT: 200px; WORD-WRAP: break-word;"><font size="2"><font face="Tahoma">VLOOKUP(A4,</font><font color="#ff0000"><font class="font8" face="宋体">过单明细表</font><font class="font7" face="Tahoma">!$E$4:$f$44</font></font><font class="font6" face="Tahoma">,2,0)</font></font></div><div style="MIN-HEIGHT: 200px; WORD-WRAP: break-word;"><font face="Tahoma" size="2">或</font></div></td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl22" height="17" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><div style="MIN-HEIGHT: 200px; WORD-WRAP: break-word;"><font size="2"><font face="Tahoma">VLOOKUP(A4,</font><font color="#ff0000"><font class="font8" face="宋体">过单明细表</font><font class="font7" face="Tahoma">!E:f</font></font><font class="font6" face="Tahoma">,2,0)</font></font></div></td></tr></tbody></table></p><p>0 也可以用false代替</p><p>不写0就是模糊查找</p>