software

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.

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

VLOOKUP would be one way ..

Try Debra Dalgleish's nice coverage at her page:
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:
www.contextures.com/xlFunctions03.html
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Bobquot; gt; wrote in message
...
gt; Hi,
gt; I'm new to Excel. I want to create an inventory database in Excel on one
gt; worksheet. Once the database is populated with part #, price, etc., I
want
gt; to be able to select items from the database on another worksheet by part
gt; number in order to populate a summary sheet with all of the database
gt; information carried over to the second sheet. I have figured out how to
set
gt; up the databse and make a list to select from on the second worksheet, but
gt; I'm having a hard time getting all of the database information to populate
my
gt; second sheet. Can this be done? Thank you for any help.