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)? |
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)? |
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)? |
All times are GMT +1. The time now is 12:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com