Can this be done?

[Guest]

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.

 

[R..VENKATARAMAN]

try vlookup function. see excel help

 

[Max]

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

---