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)?