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!
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!