[求助]如何快速制作进销存库存表

cjm120

<h2><font face="宋体">&nbsp;比如：有两张表格，每张表格里都有上百种型号的商品，其中一张里已经输入了各个型号商品的数量跟金额，那如何把这张输好数量跟金额的表格根据型号相同的商品一一对应地导入另一张表格中</font></h2>

章慧珍

[hide]可用VLOOKUP函数实现,最好用具体表格[/hide
]

Qinjabil

<p>没附件吗？</p>

水晶06

<p>希望能有帮助</p>

蒲公英YYY

<p>看看</p>

hai

看看!

亭

看下

zhangh9000

<p></p><p>给做了个附件,SHEET1是你<span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">的第一张表，</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">SHEET2</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">是你要求的表。合你要求？</span><br/></p>

peisn02

<p>学心一下下</p><p>&nbsp;</p><p>&nbsp;</p>

zhenghai0504

<p>借鉴一下</p><p></p>