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.