建议增加代码以便区分同名同规格的不同产品,设数据如图:
将公式
=if(iserror(vlookup(a2,sheet1!a:e,2,0)),"",vlookup(a2,sheet1!a:e,2,0))
复制后粘贴到"b2"单元格;
"c2"单元格公式为:
=if(iserror(vlookup(a2,sheet1!a:e,3,0)),"",vlookup(a2,sheet1!a:e,3,0))
"d2"单元格公式为:
=if(iserror(vlookup(a2,sheet1!a:e,4,0)),"",vlookup(a2,sheet1!a:e,4,0))
"e2"单元格公式为:
=if(iserror(vlookup(a2,sheet1!a:e,5,0)),"",vlookup(a2,sheet1!a:e,5,0))
选中:b2:e2"单元格,对准"e2"单元格右下角,光标成"+"状时,按住左键向下拖,如图:
![](https://ask-fd.zol-img.com.cn/g7/M00/01/0A/ChMkLGUwwG6IDVySAAClyn1Nf5sAAWFGgPd5s8AAKXi074.jpg)
这时输入代码,如图:
![](https://ask-fd.zol-img.com.cn/g7/M00/01/0A/ChMkLGUwwG-IAc6NAACcJ-z4TZAAAWFGgPe3zoAAJw_706.jpg)
注:图片如何调入,我还没有方法可提供.
有何问题,请追问.