I have a 32 page spreadsheet set up to track different sized trailers and the parts they are made up of. On one sheet labeled "parts list" I have set up a list of part numbers in column A - Vendor name in Column B and part size in Column C. I would like to go to one of the other sheets and be able to type in a part number in Column A and have its corresponding Vendor name and part size pulled over and place in Column's B & C respectively.

Can this be done????

C Hunter