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.