If column entry matches between worksheets, fill other columns in

Hey guys,

So I have two worksheets, BOM (Bill of Materials) and Quotes (which imports a huge table from a mySQL database)

The BOM has columns for: part_ID, name, manufacturer, model_number, pri_vendor, alt_vendor, cost, etc.
the only columns which are populated in BOM are part_ID and name, the rest are left blank, to be populated by the quotes table

The table in quotes has the same columns as the BOM, but they are all populated already

The formula currently resides in the manufacturers column of the BOM. It sees the match between part_ID in the BOM and quotes table, and then fills in the manufacturers information into the manufacturers column of the BOM.

Please Login or Register  to view this content.

manufacturers column in quotes table > quote!$C$2:$C$377
cell with Part_ID in BOM > $L13
column with Part_ID in quotes table > quote!$A$2:$A$377

I am hoping to get the formula to not only copy over the manufacturers info, but all the other columns as well

Any help would be greatly appreciated