Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically fill info from another spreadsheet?
I have two seperate spreadsheets, one inventory (A) and one for customer
orders (B). Is it possible to enter the name of product in spreadsheet (B) and have the next cell automatically fill in product number from spreadsheet (A)? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically fill info from another spreadsheet?
=Sheet1!A1
"Christine" wrote: I have two seperate spreadsheets, one inventory (A) and one for customer orders (B). Is it possible to enter the name of product in spreadsheet (B) and have the next cell automatically fill in product number from spreadsheet (A)? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically fill info from another spreadsheet?
Believe what you need can be achieved either via VLOOKUP or INDEX/MATCH
Try Debra Dalgleish's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Christine" wrote: I have two seperate spreadsheets, one inventory (A) and one for customer orders (B). Is it possible to enter the name of product in spreadsheet (B) and have the next cell automatically fill in product number from spreadsheet (A)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel automatically enter the current date in a spreadsheet? | Excel Discussion (Misc queries) | |||
Can an Excel Spreadsheet automatically sort new data? | Excel Worksheet Functions | |||
Excel should not automatically extend series or fill values | Excel Discussion (Misc queries) | |||
fill out a scanned form in excel spreadsheet ? | Excel Discussion (Misc queries) | |||
How do I create spreadsheet that automatically updates numbers/va. | Excel Discussion (Misc queries) |