如何设置引用函数

小村夫

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">如何设置函数，使总表以单位为关键字段，引用总表中的整行数据到各个分表中去。谢谢了！</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><p><font face="Times New Roman">&nbsp;</font></p></span></p><p><font face="Times New Roman">&nbsp;</font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">总表：</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><span lang="EN-US" twffan="done"><font face="Times New Roman">A<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>B<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>C<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>D<span twffan="done" style="mso-spacerun: yes;">&nbsp; </span></font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><font face="Times New Roman">1<span twffan="done" style="mso-spacerun: yes;">&nbsp; </span></font></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">单位</span><span lang="EN-US" twffan="done"><span twffan="done" style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;&nbsp; </font></span></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">收入</span><span lang="EN-US" twffan="done"><span twffan="done" style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;&nbsp;&nbsp;&nbsp; </font></span></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">支出</span><span lang="EN-US" twffan="done"><span twffan="done" style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></span></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">结余</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><font face="Times New Roman">2<span twffan="done" style="mso-spacerun: yes;">&nbsp; </span></font></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">甲局</span><span lang="EN-US" twffan="done"><font face="Times New Roman"><span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp; </span>2000<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp; </span>600<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1400</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><font face="Times New Roman">3<span twffan="done" style="mso-spacerun: yes;">&nbsp; </span></font></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">乙局</span><span lang="EN-US" twffan="done"><font face="Times New Roman"><span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp; </span>3000<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp; </span>800<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2200 </font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><font face="Times New Roman">4<span twffan="done" style="mso-spacerun: yes;">&nbsp; </span></font></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">丙局</span><span lang="EN-US" twffan="done"><font face="Times New Roman"><span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp; </span>4000<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp; </span>1000<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>3000</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><p><font face="Times New Roman">&nbsp;</font></p></span></p><p><font face="Times New Roman">&nbsp;</font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">预期效果：</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">分表</span><span lang="EN-US" twffan="done"><font face="Times New Roman">1</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><font face="Times New Roman"><span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp; </span>A<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>B<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>C<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>D</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><font face="Times New Roman">1<span twffan="done" style="mso-spacerun: yes;">&nbsp; </span></font></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">单位</span><span lang="EN-US" twffan="done"><span twffan="done" style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;&nbsp; </font></span></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">收入</span><span lang="EN-US" twffan="done"><span twffan="done" style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></span></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">支出</span><font face="Times New Roman"><br/>&nbsp;&nbsp;&nbsp;<span lang="EN-US" twffan="done"><span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></font><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">结余</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><font face="Times New Roman">2<span twffan="done" style="mso-spacerun: yes;">&nbsp; </span></font></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">甲局</span><span lang="EN-US" twffan="done"><font face="Times New Roman"><span twffan="done" style="mso-spacerun: yes;">&nbsp; </span>2000<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>600<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1400</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><p><font face="Times New Roman">&nbsp;</font></p></span></p><p><font face="Times New Roman">&nbsp;</font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">分表</span><span lang="EN-US" twffan="done"><font face="Times New Roman">2</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><font face="Times New Roman">A<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>B<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;</span><span twffan="done" style="mso-spacerun: yes;">&nbsp;</span>C<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>D</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><font face="Times New Roman">1<span twffan="done" style="mso-spacerun: yes;">&nbsp; </span></font></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">单位</span><span lang="EN-US" twffan="done"><span twffan="done" style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;&nbsp; </font></span></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">收入</span><span lang="EN-US" twffan="done"><span twffan="done" style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></span></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">支出</span><span lang="EN-US" twffan="done"><span twffan="done" style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></span></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">结余</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><font face="Times New Roman">2<span twffan="done" style="mso-spacerun: yes;">&nbsp; </span></font></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">乙局</span><span lang="EN-US" twffan="done"><font face="Times New Roman"><span twffan="done" style="mso-spacerun: yes;">&nbsp; </span>3000<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>800<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2200</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><p><font face="Times New Roman">&nbsp;</font></p></span></p><p><font face="Times New Roman">&nbsp;</font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">分表</span><span lang="EN-US" twffan="done"><font face="Times New Roman">3</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><p><font face="Times New Roman">&nbsp;</font></p></span></p><p><font face="Times New Roman">&nbsp;</font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><font face="Times New Roman">A<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>B<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>C<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>D</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><font face="Times New Roman">1<span twffan="done" style="mso-spacerun: yes;">&nbsp; </span></font></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">单位</span><span lang="EN-US" twffan="done"><span twffan="done" style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;&nbsp; </font></span></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">收入</span><span lang="EN-US" twffan="done"><span twffan="done" style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></span></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">支出</span><span lang="EN-US" twffan="done"><span twffan="done" style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></span></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">结余</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" twffan="done"><font face="Times New Roman">2<span twffan="done" style="mso-spacerun: yes;">&nbsp; </span></font></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">丙局</span><span lang="EN-US" twffan="done"><font face="Times New Roman"><span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp; </span>4000<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp; </span>1000<span twffan="done" style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>3000</font></span></p> wrq1flDt.rar (1.83 KB, 下载次数: 8)

2007-11-2 13:06 上传

点击文件名下载附件
如何设置引用函数

<br/>

[此贴子已经被作者于2007-11-2 13:07:11编辑过]

tony@cq

<p>用VLOOKUP函数可以解决，具体请传附件。</p>

wanglei569

pihIY5rr.rar (3.8 KB, 下载次数: 22)

2007-11-2 13:17 上传

点击文件名下载附件
如何设置引用函数

<br/>是不是这样？

tolife

p 这个挺有难度吧[em02]

tolife

看上去好难的.要下心学习了[em02]