How can I pull data from one Excel worksheet to another based on matching Part Number?

I have two spreadsheets. One has a part-number column with a bunch of alphanumeric strings that are motor replacement part numbers, plus a series of additional columns of information about each part so they can be included in an online store’s database selling these parts.

The other has just three columns, a first column with many of the same part numbers the main sheet has, and two additional columns for how many cylinders the motor the part fits has, and another for whether it is a 2 or 4 stroke motor.

How can I write a formula to match part numbers and write the cylinder and stroke numbers into columns on the end of the existing larger sheet describing the parts with columns for Part-number, Name, Description, Price, Sale-price, Ship-weight, etc?