Combining Columns from two different excell spreadsheets into one

I have a spreadsheet with different products on it, I would like to use the short product name or product URL key to search the second spreadsheet for the product description and insert the product description next to the corresponding product name. I would then like the Meta Tag Keywords searched on another spreadsheet and copied to the correct column.