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.
Screen Shot 2018-08-20 at 7.50.55 am.png
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.
Screen Shot 2018-08-20 at 7.59.52 am.png
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!
Bookmarks