Lookup

I have to regularly write long lists of items into stock.
If I had a list of products with code numbers on a worksheet is it possible by entering the code on a separate worksheet to have the product description to automatically print into an adjacent column.
This is my first post so please excuse me if the description of my needs is a bit vague.

Yes

I would suggest that you have a look at the Help for the VLOOKUP function. Proved that the description is to the right of the part number, this should work for you.

Here is an example of vlookup that You could use