Howdy,

I have an Excel Spreadsheet with five headers

Product name
Supplier
Product code
Cust number
Revision date

The problem is I have another spreadsheet with the "Product Codes" that
are from 3 to 6 char long.
I need to merge these sheets together some how. I would do it
manually but I have a 20 page spreadsheet. (sigh)

If I export the "Product Codes" field only into my Master spreadsheet,
sort the spreadsheet by "Product Name"

(Please note the first 3 to 5 letters of the "Product Code" match up
with the "Product Name")

Is there an if statement I can use to match and insert the "Product
Code with the Product Name?

For example

Product Name| Supplier Product Code| Cas # | RevDate |
Exported Prod code
Acetone Dow 555-50
11/04 Ace111

Toc855

Utz665
The Product Code field is missing because I have another spreadsheet
with Codes that needs to match up with the Product name.

I copied all of the product codes into the excel spreadsheet and sorted
them
what if statement can I use to put the Exported field in Product code
field and match. The correct Exported field should be Ace111

if product name = Product code on spreadsheet insert Product code
?????

Any help will be greatly appreciated..


--
Patsy
------------------------------------------------------------------------
Patsy's Profile: http://www.excelforum.com/member.php...o&userid=16026
View this thread: http://www.excelforum.com/showthread...hreadid=274913