I have created a worksheet that creates all my orders, delivery notes etc
from a cost sheet.

Is there any way I can set up some sort of database in excel where I can
type in a product code of an item in one cell then have an automatic
description of that item be displayed in the next column?

Bearing in mind I know very little of Access (which I suspect is what I'll
need).

I would appreciate nay help given on this matter.

Jonny