Sounds like a perfect chance to learn about =vlookup() or =index(match()).

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble

Fred's wrote:

Hello,

Hope that someone could help me.

I have an inventory in excel with the following information.
Skid #, Order number, Style, Color ect...

and another sheet in an other workbook that is my shpping information
sheet.

I would like to be able to enter only the order number in my shpping
information sheet and that all other specific cells to be populated
with the information related to this order number.

Is it possible?????

Please help, I'm a beginner in this matter.

Thank you,
Fred's

--

Dave Peterson