Aligning cells with matching values

[Hugo Puflett]

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 :)

[#2]

Mr. Puflett

May I suggest that you attach a dummy file and indicate what you needed so that people here will have a better view of your problem and can offer their recommendations faster..

thank you