What formula/rule can I use that will automatically match and pull info

I don't know if this exists, but I'm hoping someone can help. I have two excel spreadsheets. One is a list of sales made, the other is a product list that has our cost per product. I'd like to use a ...