Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graphing Database Growth Rate | Charts and Charting in Excel | |||
Need help with exel database | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
i want to open database exclusively | Excel Discussion (Misc queries) | |||
PLEASE HELP!? Creating a simple database with excel, minor setback | Excel Worksheet Functions |