用Excel函数快速填入部门名称（常用推荐）
<p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 12pt; LINE-HEIGHT: 150%; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;">下面我就以<span lang="EN-US">Excel 2000</span>中的一个<span lang="EN-US">“</span>学校职工情况表<span lang="EN-US">”</span>为例，来告诉大家如何利用<span lang="EN-US">Excel</span>函数快速填入部门名称。如图<span lang="EN-US">1</span>所示，要求填入相应部门代号后的所在部门名称。<span lang="EN-US"><p></p></span></span></p><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: 150%; TEXT-ALIGN: center; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;"><shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" opreferrelative="t" ospt="75" coordsize="21600,21600"><stroke joinstyle="miter"></stroke><formulas><f eqn="if lineDrawn pixelLineWidth 0"></f><f eqn="sum @0 1 0"></f><f eqn="sum 0 0 @1"></f><f eqn="prod @2 1 2"></f><f eqn="prod @3 21600 pixelWidth"></f><f eqn="prod @3 21600 pixelHeight"></f><f eqn="sum @0 0 1"></f><f eqn="prod @6 1 2"></f><f eqn="prod @7 21600 pixelWidth"></f><f eqn="sum @8 21600 0"></f><f eqn="prod @7 21600 pixelHeight"></f><f eqn="sum @10 21600 0"></f></formulas><path oconnecttype="rect" gradientshapeok="t" oextrusionok="f"></path><lock aspectratio="t" vext="edit"></lock></shapetype><shape id="_x0000_i1025" alt="用Excel函数快速填入部门名称" type="#_x0000_t75" style="WIDTH: 300pt; HEIGHT: 137.25pt;"><imagedata ohref="http://img.skycn.com/articleimg/20030724-19.jpg" src="file:///C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\msohtml1\01\clip_image001.jpg"></imagedata></shape><br/></span><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;">图<span lang="EN-US">1<p></p></span></span></p><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: 150%; TEXT-ALIGN: center; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;"> 1. </span><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;">选取需要填入所在部门的范围<span lang="EN-US">F4:F118</span>。<span lang="EN-US"><br/> 2. </span>单击格式工具栏上的<span lang="EN-US">[</span>插入函数<span lang="EN-US">]</span>按钮，接着在<span lang="EN-US">“</span>粘贴函数<span lang="EN-US">”</span>对话框中的<span lang="EN-US">“</span>函数分类<span lang="EN-US">”</span>栏选择<span lang="EN-US">“</span>查找与引用<span lang="EN-US">”</span>，<span lang="EN-US">“</span>函数名<span lang="EN-US">”</span>选择<span lang="EN-US">“LOOKUP”</span>，单击<span lang="EN-US">[</span>确定<span lang="EN-US">]</span>按钮（如图<span lang="EN-US">2</span>）。</span></p><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: 150%; TEXT-ALIGN: center; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;"> 3. </span><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;">在弹出的<span lang="EN-US">“</span>选定参数<span lang="EN-US">”</span>对话框中选择参数组合方式，单击<span lang="EN-US">[</span>确定<span lang="EN-US">]</span>按钮。<span lang="EN-US"><br/> 4. </span>分别在查找范围中输入<span lang="EN-US">E4:E118</span>，在单列范围中输入<span lang="EN-US">H4:H8</span>，在输出结果中输入<span lang="EN-US">I4:I8</span>（如图<span lang="EN-US">3</span>）。最后按下<span lang="EN-US">Ctrl+Shift+Enter</span>键，单击<span lang="EN-US">[</span>确定<span lang="EN-US">]</span>按钮即可。<span lang="EN-US"><p></p></span></span></p><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: 150%; TEXT-ALIGN: center; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" opreferrelative="t" ospt="75" coordsize="21600,21600"><stroke joinstyle="miter"></stroke><formulas><f eqn="if lineDrawn pixelLineWidth 0"></f><f eqn="sum @0 1 0"></f><f eqn="sum 0 0 @1"></f><f eqn="prod @2 1 2"></f><f eqn="prod @3 21600 pixelWidth"></f><f eqn="prod @3 21600 pixelHeight"></f><f eqn="sum @0 0 1"></f><f eqn="prod @6 1 2"></f><f eqn="prod @7 21600 pixelWidth"></f><f eqn="sum @8 21600 0"></f><f eqn="prod @7 21600 pixelHeight"></f><f eqn="sum @10 21600 0"></f></formulas><path oconnecttype="rect" gradientshapeok="t" oextrusionok="f"></path><lock aspectratio="t" vext="edit"></lock></shapetype><shape id="_x0000_i1025" alt="用Excel函数快速填入部门名称" type="#_x0000_t75" style="WIDTH: 296.25pt; HEIGHT: 150pt;"><imagedata ohref="http://img.skycn.com/articleimg/20030724-21.jpg" src="file:///C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\msohtml1\01\clip_image001.jpg"></imagedata></shape><br/></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">图<span lang="EN-US">3<br/> </span>这样，眨眼间对应教职员工所在部门的名称就填好了，看看最后的结果，是不是感觉很方便！<span lang="EN-US"><br/> </span>附表为函数<span lang="EN-US">LOOKUP</span>的结构说明。 </span><span lang="EN-US"><p></p></span></p></span> 晕，图片显示不出来啊 楼主，你的图叻？ <p>在资源中心里面挂了一下。</p> <p>感谢楼主！</p> 本帖最后由 qgystme 于 2015-9-8 13:29 编辑:lol :lol :lol 比较简单的EXECEL应用,大家如果喜欢学习，应该到excelhome去逛逛 <p>看了半天不明白，是否就是VLOOKUP的功能啊，感觉有些像？</p><p></p> 感谢楼主 kan bu dao
页:
[1]
2