Database
 

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

Hi Jonny

See the Excel help for the VLookup worksheet function

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jonny" wrote in message ...
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