Hi Steve,

Consider using Excel's VLookup function.

See Excel's Help and see also Debra Dalgleish's tutorial at:

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


---
Regards,
Norman



"Steve Hopkins" <Steve wrote in message
...
I need to add a number of a product automatically from another program into
excel and then excel automatically put in a long preset description