View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Lookup & Insertion Of Data

I have two worksheets. On the first there is a column listing Manufacturers
Part Numbers. The listing is textual content and is OK to have repeating
items in the list.

The second worksheet contains a 3 column table of Manufacturers Part Numbers
(same content format as worksheet one), Manufacturer Name, and our In-House
Part Number.

I need to check the Manufacturers Part Numbers on worksheet one against
worksheet two and if a match occurs I need to copy Manufacturers Name & In
House Part Number data from worksheet two back to worksheet one in the
corresponding / adjacent two columns.