表二B2=VLOOKUP(A2,Sheet2!A:D,2,0),表二C2=VLOOKUP(A2,Sheet2!A:D,3,0),表二D2=VLOOKUP(A2,Sheet2!A:D,2,0),按住B2C2D2同时下拉到你所需要的地方试试看,问题解决了没有<span class=\\\"evaluate\\\" id=\\\"evaluate-1280150289\\\" ><span class=\\\"evaluate-outer\\\"><span class=\\\"evaluate-inner\\\"><b class=\\\"evaluate-tip\\\" style=\\\"display:none\\\">赞同</b><span><b class=\\\"evaluate-num evaluate-num-fixed\\\">0</b></span></span></span></span><span class=\\\"f-pipe\\\">|</span><span class=\\\"comment\\\" id=\\\"comment-1280150289\\\">评论</span>
|