I have a Excel book with Two sheets
Sheet1 – List of Items with ID No. and Qty Column
Sheet2 – List of some selected items from sheet1 without Qty
My goal is to search sheet2 items in sheet1 and get the Qty to Sheet2 in the same raw of the item.
would you please help me how to create the formula
Thank you very much