Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|