I've searched through the forums, and I'm having trouble applying any
solutions to my situation.

I have two worksheets in my workbook, "MISC" and "durhambins". Here are the
headers and one row of data from MISC.

Part Description
400037 Instant Adhesive, Loctite 480


Here are the headers and one row of data from durhambins.

Part Description Bin
400037 Instant Adhesive, Loctite 480 FRIDGE




I need to have a column added to MISC that holds the correct BIN number for
records with matching Part numbers (the first columns). So that in the end,
the result of the above records would be:

Part Description Bin
400037 Instant Adhesive, Loctite 480 FRIDGE


Thank you in advance for any help.