Copying big list of corresponding data to another spreadsheet with same data, but in diffe

So I am given a list of data (SKUs) in a column (spreadsheet 1), and must transfer data (spreadsheet 2) giving the URL of each SKU to the corresponding SKU in spreadsheet 2.
So for example, Spreadsheet 1 has: PR00010171_BK |||| BLANK
Spreadsheet 2 has: PR00010171 corresponding.url
but they are not in the same rows, so a copy and paste is not possible. Does anyone know how of any functions that I can use to quickly use the SKU to find the corresponding URL and drag it down or something of the sort? Thanks, any help would be appreciated.
If needed, I can upload the excel files I am referring to.

here is a link for what I am referring to, http://i.imgur.com/WEFtZwP.png

spreadsheet 1 is to the left, and spreadsheet 2 is to the right.

currently, I am copying the SKU of spreadsheet 1, finding it in spreadsheet 2, and copying the corresponding URL into spreadsheet two.