Aligning Cells with Matching Values

[hjpufl]

Hi, I have a spreadsheet with thousands of product codes, and corresponding data of stock on hand and weekly orders.

I would like to match the product codes with each other to automatically align, in each row, the data of stock on hand and orders.

For example column C has the product codes for the spreadsheet, while column K and L include the copied and pasted stock on hand values.
I would like to align, say the BPLOBL value in K, and its 15 value, with the BPLOBL in Column C.

From what I gather, I need to be using a combination of the INDEX and MATCH functions but I cant get the syntax right!!

Thanks for your help!

 

[shg]

There's a workbook with a macro that will do that at https://app.box.com/shared/elrnbidnr7