Excel: Matching/Sorting

Hello,
I'm dumb, lazy, and having trouble finding an efficient way to complete a price list for my store. Here's what I need to do.

I have two files. One lists the items I carry (store inventory), the other is much longer and lists all of the items available from my distributor. The problem is that my store inventory list doesn't have any UPC codes on it, it has company product codes. The distributor list has both. I need to put a column of UPC codes into my store inventory list.

I'd like to paste the distributor's list of product and UPC codes into my store inventory list and somehow sort to match product codes, thereby matching UPC codes. Regular A-Z sorting did not work because there are far more distributor entries than inventory entries.

Can anyone help me?

Thank you!!!