Can this be done?
 

Hi,
I'm new to Excel. I want to create an inventory database in Excel on one
worksheet. Once the database is populated with part #, price, etc., I want
to be able to select items from the database on another worksheet by part
number in order to populate a summary sheet with all of the database
information carried over to the second sheet. I have figured out how to set
up the databse and make a list to select from on the second worksheet, but
I'm having a hard time getting all of the database information to populate my
second sheet. Can this be done? Thank you for any help.

Can this be done?
 

try vlookup function. see excel help


"Bob" wrote in message
...
Hi,
I'm new to Excel. I want to create an inventory database in Excel on one
worksheet. Once the database is populated with part #, price, etc., I
want
to be able to select items from the database on another worksheet by part
number in order to populate a summary sheet with all of the database
information carried over to the second sheet. I have figured out how to
set
up the databse and make a list to select from on the second worksheet, but
I'm having a hard time getting all of the database information to populate
my
second sheet. Can this be done? Thank you for any help.

Can this be done?
 

I'm having a hard time getting all of the database
information to populate my second sheet.

VLOOKUP would be one way ..

Try Debra Dalgleish's nice coverage at her page:
http://www.contextures.com/xlFunctions02.html
(there's also a sample book for d/l there)

Another way would be to use INDEX / MATCH
which Debra also covers at her:
http://www.contextures.com/xlFunctions03.html
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bob" wrote in message
...
Hi,
I'm new to Excel. I want to create an inventory database in Excel on one
worksheet. Once the database is populated with part #, price, etc., I
want
to be able to select items from the database on another worksheet by part
number in order to populate a summary sheet with all of the database
information carried over to the second sheet. I have figured out how to
set
up the databse and make a list to select from on the second worksheet, but
I'm having a hard time getting all of the database information to populate
my
second sheet. Can this be done? Thank you for any help.