Match 2 lists based on Part Number

Hello, Excel newbie here. Trying to accomplish a task in Excel which I have faith is possible, just haven't been able to figure it out on my own. Hopefully the experts here can help out or at least tell me it's a lost cause I'll do my best to describe what I'm trying to accomplish. In a nutshell I have 2 lists I'm trying to combine based on a part number reference:

List #1: Customer, Part & Price (parts sometimes appear more than once, under different customers)
List #2: Part & Cost

I'm trying to add a Cost column (data from list #2) to List #1 and match the costs up to the appropriate parts.
I've gone round and round with index, match, lookup, vlookup but I'm afraid I'm in over my head.
Any help or direction would be greatly appreciated!

James

excel_example.jpg

A .jpg file is not much use, as all you can do is look at it - in future, post an Excel file so we can see how your data varies.

That said, try this in D2:

=VLOOKUP(B2,E:F,2,0)

and copy down.

Hope this helps.

Pete

Wow Pete. My first post in the forum and I have a working answer in about 5 min. Thanks so much!