Excel 2007 : Database Help

[Ziantist]

I have created a Excel Database for estimating, my DB includes, item description, item code, unit price , labor rate etc.

I have created an estimating sheet and i would like to reference items in the database. i.e I have data validation on the estimating page which enables me to pick items from the DB on a drop down menu. What i would like to do is display field information of the item selected and automatically fill the estimating sheet with unit price, laboor rates etc.

i.e. I go to my Estimating sheet (which is blank) drop down menu select 20Amp receptacles, then automatically the data for Unit_Price, Labor_rates etc is filled with info from the corresponding cell in my DB.

thanks....

[Palmetto]

You need to use one of the lookup functions such as VLOOKUP or perhaps a combination of INDEX & MATCH. To get a more precise answer, upload a sample of your workbook so we can see the structure.

See this link for more information on the above functions.
Contextures

Here is the basic idea:
Let's say your database is Sheet1
A1: Item Code
B1: Item Description
C1: Unit Price
Row2 and below are data cells

On the Esitmating sheet
A1:C1 match the headers in the database

A2: = dropdown of item codes
B2: =VLOOKUP(A2,Sheet1!A2:C100,2,0)
C2: =VLOOKUP(A2,Sheet1!A2:C100,3,0)