急·········！求救

dzbmilky

<div><p class="MsoNormal"><font face="宋体" size="4"><span style="FONT-SIZE: 14pt;">调薪遇到<span lang="EN-US">excel</span>技术难题，求高人解决：）<span lang="EN-US"><p></p></span></span></font></p></div><div><p class="MsoNormal"><font face="宋体" size="4"><span lang="EN-US" style="FONT-SIZE: 14pt;">&nbsp;<p></p></span></font></p></div><div><p class="MsoNormal"><font face="宋体" size="4"><span style="FONT-SIZE: 14pt;">如附件：<span lang="EN-US"><br/></span>调薪要保证<strong><b><font face="宋体" color="#ff0000"><span style="COLOR: red; FONT-FAMILY: 宋体;">新工资</span></font></b></strong>大于或等于<strong><b><font face="宋体" color="#ff0000"><span style="COLOR: red; FONT-FAMILY: 宋体;">新工资级别</span></font></b></strong>下<b><font color="#ff0000"><span style="FONT-WEIGHT: bold; COLOR: red;">离旧工资最近</span></font></b>的对应级别工资。<span lang="EN-US"><br/></span>比如旧工资<span lang="EN-US">1460</span>，新工资要在新工资级别表里找到大于<span lang="EN-US">1460</span>的最近的一个数，即<span lang="EN-US">1471</span>。<span lang="EN-US"><br/></span>不知<span lang="EN-US">excel</span>如何实现？<span lang="EN-US"><p></p></span></span></font></p><p class="MsoNormal"><font face="宋体" size="4"><span style="FONT-SIZE: 14pt;">感谢各位专家！<span lang="EN-US"><p></p></span></span></font></p></div>

sotamajp

excel的自带的函数中有具备这个功能的函数，你找找看

dzbmilky

请问是那个函数？

无尘道长

VLOOKUP