Hi Ed Try using Excel's VLookup function.

See Excel's help or see Debra Dalgleish's tutorial at:

http://www.contextures.com/xlFunctions02.html


---
Regards,
Norman



"Ed.Rob" <EdRob@discussions.microsoft.com> wrote in message
news:416D47A0-2F8D-490D-AEF1-61E3944F1E0A@microsoft.com...
>I have a situation where I want to match 5,000 part numbers in one workbook
> against a seoarate 10,000 master part number workbook, copy two cells from
> the matched row and paste them in the original workbook row. The search
> would
> also be a loop for the 5,000 workbook.
>
> Where can I find an example of this type of VB coding? I have used the
> "Help" from VB whic is good but am still confused. Do I need to be an
> expert
> in VB to accomplish this task?
> Would appreciate any suggestions.
> Ed
>