hi all!

Can anyone help to solve the follow problem:

Spreadsheet A has the follow column:
-PartNo
-VendorCode
-Quantity

Spreadsheet B has
-PartNo
-PartName
-Unit Price

PartNo in both table are related and unique.
There are thousand of data in each spreadsheet. It is impossible to use
the if statement to join two tables, Also.. I understand it can use
Access to do it very easily, but I do not want to use Access... can I
do it in Excel?
Pls help...

How can I join these two tables into one table, has all those
information, as:
New spreadsheet
-PartNo
-VendorCode
-Quantity
-PartName
-Unit Price

Thank you very much for any suggestion.


--
vitality
------------------------------------------------------------------------
vitality's Profile: http://www.excelforum.com/member.php...o&userid=27267
View this thread: http://www.excelforum.com/showthread...hreadid=467742