Picking up information from one excel sheet t

Hello,
I have a excel work sheet with a list of products with code numbers and differenct characteristics of the each product in different columns of the sheet.
I open another excel sheet and by putting the code number of the product I want all charateristics of the products to come on the new sheet. Please help