Database

[Guest]

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

 

[Ron de Bruin]

Hi Jonny

See the Excel help for the VLookup worksheet function