Pulling data from one spreadsheet based on unique identifier

Firstly i hope this is in the right forum.

I have two spreadsheets:

1) One has Product code (unique), cost, price and a few other columns of data.

2) The other has the same product codes but with some different columns of data e.g stock location.

I want to be able to add the cost column of data to the second spreadsheet. However because the products aren't in the same order its not a simple copy and paste job.

Is there away i can populate the cost column in the second spreadsheet with the cost data from the first spreadsheet based on the product code?

Thanks