1. How To ...... for Lookup Mfgr PN from XL List
1.1. Create Excel File for Lookup

Excel file must have single column of MPN, and data must be in a range named MFGRLIST

 

 

1.2. How to Lookup Mfgr Part Number from XL List

Enter Inventory Mgt/Inventory Control Management/Lookup Manufacturer Part Number from XL List Module

 

 

The following screen will appear:

 

 

Depress the "Browse for Excel File" to locate the file name created

 

 

Double Click on the File name and the following results appear.  Two XL files are created, one XL file lists the Mfgr Part Numbers found in system, (which is the ones that appear on screen)and the other XL file lists the Mfgr Part Numbers not found.